Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
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
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
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
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)