Pie Chart format

[alec1982]

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,

[matt_crowther]

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

[alec1982]

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

[matt_crowther · Accepted solution]

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

[whiteline]

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)