Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
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
matt_crowther
Luminary Alumni
Luminary Alumni

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
matt_crowther
Luminary Alumni
Luminary Alumni

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
Specialist II
Specialist II
Author

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
Luminary Alumni
Luminary Alumni

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

whiteline
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)