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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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]) ))