Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Spartan27215
Partner - Creator
Partner - Creator

Pie Chart with 2 measures

I have 2 measures that I would like to show in a pie chart, but it will only take one measure, so I am trying to figure out how to do this. I have one measure that is the Med$, and the other is Rx$. By using the Pie chart I would like to see the %Med$ and %Rx dollars. Obviously the denominator is the Med$ + Rx$. Since neither of these is represented as a dimension, not sure how to pull this off. Is there a way?

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
anat
Master
Master

can you try like below

dim:

valuelist(measure1,measure2)

expression:

if(valuelist(measure1,measure2)='measure1',sum(measure1logic),sum(measure2logic))

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-SENSE-Pie-Chart-with-two-measures/td-p/40407

 

View solution in original post

1 Reply
anat
Master
Master

can you try like below

dim:

valuelist(measure1,measure2)

expression:

if(valuelist(measure1,measure2)='measure1',sum(measure1logic),sum(measure2logic))

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-SENSE-Pie-Chart-with-two-measures/td-p/40407