Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Pie Chart format

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,

1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

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

View solution in original post

4 Replies
Highlighted
Luminary
Luminary

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Luminary
Luminary

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

View solution in original post

Highlighted
Master II
Master II

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)