Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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