Vendor Info: more

Showing posts with label more. Show all posts

Sunday, March 5, 2017

More on Dual Others in chart using AGGR

In a previous blog post (More On Dual - http://qliktips.blogspot.com/2009/09/more-on-dual.html) I proposed a method for getting better labels in a Pie chart by using Dual to create the label and the value in the expression:

Dual(Country & ( & Num(Sum(Sales)/Sum(Total Sales),0.00%) & ) & chr(13) & Num(Sum(Sales),#,##0), Sum(Sales))

A problem has been pointed out to me by one of my readers - if the number of slices is restricted (10 by default), then the "Others" does not display correctly:

We can fix this by limiting the number of dimensions using an AGGR statement with RANK in a calculated dimension:

=If(aggr(rank(Sum(Sales)), Country) <= 4, Country, Others)

So here, I am checking if the rank of the dimension is less than or equal to 4. If so, just use the Country name, if not, use "Others".

Now, there is still a slight problem with this and the Dual - the name is still blank. So, we need to modify the expression to check for a blank name:

Dual(If(Len(Country)>0,Country,Others) & ( & Num(Sum(Sales)/Sum(Total Sales),0.00%) & ) & chr(13) & Num(Sum(Sales),#,##0), Sum(Sales))

(It will be blank because there are actually multiple values).

So, all should be well!

Of course, this doesnt just apply to Pie charts (thankfully!) - this method of restricting the dimension using Rank and AGGR can be used in any chart - including Straight Tables!

Go to link Download

Tuesday, November 1, 2016

Cannot copy file not enough free disk space Delete one or more files to free up space then try again Error

This error occurs even though if you have more free space; then your File System of your Hard Drive (C:/D:/E:/F: etc) must be changed to NTFS from FAT32 in order to avoid this error.

Method I :
There is an inbuilt option in Windows XP/Vista/7 OS to convert your File System to NTFS from FAT32.

Click Start > Run > type "cmd" and hit Enter.
This will open the command prompt window.
If you want to convert the drive D: to NTFS, type the cmd below exactly without quotes.
"convert d: /fs:ntfs"and hit Enter key.
When prompted enter the volume label.

Method II :
You can also change the File System to NTFS in XP/Vista/7 by using a Freeware called "EaseUS Partition Master - Home Edition" .

Free download the copy of EaseUS Partition Master Home Edition from the link below.
http://www.partition-tool.com/download.htm
Install this freeware in your PC and launch it.
Select the drive which you want to convert and right click on it.
Select Convert to NTFS and click Apply button in the toolbar menu to complete the operation.

Go to link Download

Tuesday, October 4, 2016

Netflix Pandora and more in 1080P to your TV with Roku Starting at 69 99

Roku is the highest rated and best value in set-top boxes for watching media from the internet and your PC on your TV, in high definition.

For under $20 a month you could subscribe to Netflix and Hulu Plus to watch almost anything you want, whenever you want, and cancel your cable or satellite subscription. These services are updated with new TV shows and movies constantly. Click below to see the listing of all currently available apps:
http://www.roku.com/roku-channel-store

The Roku box also plays your computer media libraries (like .mp3, .mov, .mkv, not .avi) over the network or attached hard drive or thumb drive. This includes photos and home videos. This article shows all compatible file types:
http://support.roku.com/entries/423946-what-media-file-types-does-the-roku-usb-media-player-channel-support

To connect to the internet, Roku uses a cat5e cable (the same kind your PC uses), but what sets Roku apart is that it also includes wireless, at prices that normally wont buy you this feature.

Roku 2 XS 1080P (Now compatible with every hookup except optical audio)

Roku 2 XD 720P (wireless connection only)

Roku 2 HD (best value)

Roku XDS (compatible with any internet, TV and audio hookups)

Roku XD

Roku HD (not recommended at this price)

Click image to enlarge (opens in new tab):

If wifi isnt important to you, and .avi support is, then you want WD TV Live instead:

Less apps, more Blu-ray, still does Netflix:

Go to link Download