Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_agustin
Contributor
Contributor

Custom Pie Chart

qlik_agustin_0-1661412095492.png

i want to produce a pie chart where C is the total of the whole pie.
after selecting in field B, A=0 and B will be equal. but if you select in field A, C>B>A.

Labels (1)
1 Solution

Accepted Solutions
qlik_agustin
Contributor
Contributor
Author

Thank you for this. Because of this i somehow understand how i will work on my current problem.
Here's how i got my ideal output.

=IF( ValueList('A', 'B', 'C') = 'A', if(count(GetCurrentSelections()>0) and getselectedcount([ID])>0,Sum({$}[A]),0),
IF( ValueList('A', 'B', 'C') = 'B', Sum({$}[B]), SUM({$}[C]) - Sum({$}[B]) ))

View solution in original post

2 Replies
brunobertels
Master
Master

qlik_agustin
Contributor
Contributor
Author

Thank you for this. Because of this i somehow understand how i will work on my current problem.
Here's how i got my ideal output.

=IF( ValueList('A', 'B', 'C') = 'A', if(count(GetCurrentSelections()>0) and getselectedcount([ID])>0,Sum({$}[A]),0),
IF( ValueList('A', 'B', 'C') = 'B', Sum({$}[B]), SUM({$}[C]) - Sum({$}[B]) ))