Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
francisco_cohen
New 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
Esteemed Contributor

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)

)

8 Replies
OmarBenSalem
Esteemed Contributor

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 :

Capture.PNG

francisco_cohen
New Contributor III

Re: Qlik SENSE Pie Chart with two measures

And what if I don't have a dimension?

OmarBenSalem
Esteemed Contributor

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)

)

francisco_cohen
New Contributor III

Re: Qlik SENSE Pie Chart with two measures

That was PERFECT!

Thank you!!!!!

You made my day!

aitmessaoudali
Contributor

Re: Qlik SENSE Pie Chart with two measures

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

aitmessaoudali
Contributor

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)

OmarBenSalem
Esteemed Contributor

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

aitmessaoudali
Contributor

Re: Qlik SENSE Pie Chart with two measures

Many thanks Omar, works perfectly.