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
QlikWorld happening right now! You can still join: REGISTER NOW
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.

1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

Ah my bad ! I've misread (it 11pm for me, so )

this should do it:

as dimension :

valueList('Hotels','AirBnb')

as a measure:

if( valueList('Hotels','AirBnb')='Hotels', sum(Hotel),

sum(AirBnB)

)

View solution in original post

13 Replies
OmarBenSalem
Partner
Partner

You can't create a pie chart with 2 measures; but u can do is sthing like follow:

dimension :

=yourDim&' (YourSecondMeasure :'&aggr(num(sum(YourSecondMeasure),'# ##0'),yourDim)&')


Measure:

sum(YourFirstMeasure)

result per analogy :

Capture.PNG

francisco_cohen
Contributor III
Contributor III
Author

And what if I don't have a dimension?

OmarBenSalem
Partner
Partner

Ah my bad ! I've misread (it 11pm for me, so )

this should do it:

as dimension :

valueList('Hotels','AirBnb')

as a measure:

if( valueList('Hotels','AirBnb')='Hotels', sum(Hotel),

sum(AirBnB)

)

francisco_cohen
Contributor III
Contributor III
Author

That was PERFECT!

Thank you!!!!!

You made my day!

aitmessaoudali
Creator
Creator

Thanks Omar, this is exacly what i've been looking for.

aitmessaoudali
Creator
Creator

Hello Omar, do you know how to do it using 3 measures, imagine we have sum(hotel), sum(AirBnb), sum(GuestHouse)

OmarBenSalem
Partner
Partner

Same logic Ali

as dimension :

valueList('Hotels','AirBnb','GuestHouse')

as a measure:

if(valueList('Hotels','AirBnb','GuestHouse')='Hotels', sum(Hotel),

if(valueList('Hotels','AirBnb','GuestHouse')='AirBnb', sum(AirBnb),

if(valueList('Hotels','AirBnb','GuestHouse')='GuestHouse', sum(GuestHouse)))

aitmessaoudali
Creator
Creator

Many thanks Omar, works perfectly.

rafaelencinas
Contributor
Contributor

Thank you a lot !