Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
francisco_cohen
Contributor III
Contributor III

Qlik SENSE Pie Chart with two measures

Hi all,

I'm working on Qlik Sense and willing to create a Pie chart with two measures.

One of my measures is: sum(Hotel)

The second measure is: sum(AirBnB)

I want to create a pie chart that shows me my share between the two measures above.

It seems so simple but I'm going around and around without figuring out how to solve this one.

Please check what I want to do in the excel example attached.

Thank you for your support.

FC.

13 Replies
Amit
Contributor
Contributor

Brilliant! Thanks 🙂

Binay_Sharma
Contributor III
Contributor III

A very good stuff. I was looking for something similar. I made it work.

if( valueList('Gross','Net')='Gross', sum({<_CMTD_Flag ={1},[_Acct_Appl_Code_Flag] ={1} >} [#uvGross Fee]),

sum({<_CMTD_Flag ={1},[_Acct_Appl_Code_Flag] ={1} >} [#uvNetAnalysisFee])

)

 

Thank you. 

rafaelencinas
Contributor
Contributor

Thanks!!
AlexJohnsyn
Contributor II
Contributor II

This worked beautifully for me too, thank you!

However, the results on the pie chart now show up as % and I cannot seem to change that at all. The calculation I'm using is a simple "sum(A/B)/1024". I should be getting the result as a number in TB. Changing the number formatting doesn't do anything at all..