Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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