topic Re: Pie Chart format in QlikView

Pie Chart format

alec1982 — Wed, 29 Aug 2012 14:03:28 GMT

Hi guys,

I have a list box that is showing locations and a Pie Chart that is showing percentage of SF per Location

Now the chart is showing correctly the Percentage of SF by Locations. Like I have 20 Locations and each one has its slice on the chart and the right Percentage.

How can I do the follwing:

If I select a location from the list box, the Pie chart shows the percentage of selected location Vs All others(In other words: One color for this location "Slice" and a second color summing all other locations"Slices").

Thxs,

Re: Pie Chart format

matt_crowther — Wed, 29 Aug 2012 14:21:49 GMT

Should be fairly straight forward.

Create a Pie Chart with no Dimensional value, add an expression similar to the following: =sum({1}Sales) and a second =sum({1-$}Sales).

The 1st could simply be sum(Sales), the 2nd gives you the total for everything excluded by your selections.

Obviously the 'Sales' is to be replaced by whatever you want to count or sum.

Hope that helps,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI

Re: Pie Chart format

alec1982 — Wed, 29 Aug 2012 15:22:00 GMT

This is helpfull but the logic that i have is a little confussing.

I think that i am going to do it differently.

I am going to build to charts the first one will show me the selections as I explained how they are showing up now and the second will show the percentage as i needed as there is no way of showing both at the same time.

Do you know how to hide and show a chart if a selection in made in a list box?

Thxs for your help

Re: Pie Chart format

matt_crowther — Wed, 29 Aug 2012 15:32:41 GMT

Look to use getselectedcount(Location) in the Conditional Show expression of the objects you wish to show / hide.

ie show when no selections made: getselectedcount(Location)=0

vice versa

getselectedcount(Location)>0

Hope that helps,

Matt - @QlikviewBI

Re: Pie Chart format

whiteline — Wed, 29 Aug 2012 16:25:08 GMT

II think the right expressions for you to show percentage are

=sum({1-$}Sales)

for others and

=sum({$}Sales)

for current selection,

scince =sum({1}Sales) equals total.

You can also achieve the same results without set analysis:

=sum(Sales)/sum(total Sales)

and

=1-sum(Sales)/sum(total Sales)