Qlik SENSE Pie Chart with two measures

[francisco_cohen]

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.

[OmarBenSalem]

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 :

[francisco_cohen]

And what if I don't have a dimension?

[OmarBenSalem · Accepted solution]

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]

That was PERFECT!

Thank you!!!!!

You made my day!

[aitmessaoudali]

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

[aitmessaoudali]

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

[OmarBenSalem]

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]

Many thanks Omar, works perfectly.

[Anonymous]

Thank you a lot !