Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
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]) ))