
Re: Pie Charts: Showing Percentage of Two Values
Maximiliano Velez Aug 4, 2015 1:05 PM (in response to Jason Wills)Create the Pie with no dimensions and the two expressions you need.
Regards

Re: Pie Charts: Showing Percentage of Two Values
Masaki Hamano Aug 4, 2015 8:52 PM (in response to Jason Wills)On QlikView, you can set multiple measures with no dimension for a pie chart, but on the other hand, you can only set one measure with a dimension as a mandatory input on Qlik Sense.
So, one way to pile up measure values on Qlik Sense pie chart is to use ValueList function as the following example:
Dimension: =ValueList('Revenue','OtherRevenue')
Measure: IF(ValueList('Revenue','OtherRevenue')='Revenue',Sum(Revenue), Sum(OtherRevenue))
Here is an explanation on ValueList().

Re: Pie Charts: Showing Percentage of Two Values
Jason Wills Aug 7, 2015 3:13 AM (in response to Masaki Hamano )Hi Masaki,
worked a treat, many thanks for that.
And thankyou for the detailed response and pointer to the ValueList function  I'm sure that's going to help me out a lot.
Thanks again.
Jason

Re: Pie Charts: Showing Percentage of Two Values
Ishu Mehta Nov 28, 2016 7:21 AM (in response to Masaki Hamano )Hi,
See, if you can help on this quesion, it is on similar lines as this post


Re: Pie Charts: Showing Percentage of Two Values
Luiz DePaula Mar 17, 2016 2:22 PM (in response to Jason Wills)Masaki,
It worked like a charm. I just would like to add that you can used with as many measures as you want. All you have to do is nest the IF statements.
ex:
Dimension= ValueList('[Total Base Charges]','[Total Accessorials]','[Total Fuel Surcharges]')
Measure=
IF(ValueList('[Total Base Charges]','[Total Accessorials]','[Total Fuel Surcharges]')='[Total Base Charges]',
Sum([Total Base Charges]),
If(ValueList('[Total Base Charges]','[Total Accessorials]','[Total Fuel Surcharges]')='[Total Accessorials]',
Sum([Total Accessorials]),
If(ValueList('[Total Base Charges]','[Total Accessorials]','[Total Fuel Surcharges]')='[Total Fuel Surcharges]',
Sum([Total Fuel Surcharges]))))
Thanks for the tip

Re: Pie Charts: Showing Percentage of Two Values
Ishu Mehta Nov 28, 2016 7:21 AM (in response to Luiz DePaula)Hi,
See if you can help with following question
