8 Replies Latest reply: Sep 11, 2018 4:29 AM by Ali Ait Messaoud

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.

FC.

• Re: Qlik SENSE Pie Chart with two measures

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 :

• Re: Qlik SENSE Pie Chart with two measures

And what if I don't have a dimension?

• Re: Qlik SENSE Pie Chart with two measures

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)

)

• Re: Qlik SENSE Pie Chart with two measures

That was PERFECT!

Thank you!!!!!

• Re: Qlik SENSE Pie Chart with two measures

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

• Re: Qlik SENSE Pie Chart with two measures

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

• Re: Qlik SENSE Pie Chart with two measures

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)))

• Re: Qlik SENSE Pie Chart with two measures

Many thanks Omar, works perfectly.