# 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.
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.

FC.

1 Solution

Accepted Solutions
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
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 :

New Contributor III

## Re: Qlik SENSE Pie Chart with two measures

And what if I don't have a dimension?

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)

)

New Contributor III

## Re: Qlik SENSE Pie Chart with two measures

That was PERFECT!

Thank you!!!!!

Contributor

## Re: Qlik SENSE Pie Chart with two measures

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

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)

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

Contributor

## Re: Qlik SENSE Pie Chart with two measures

Many thanks Omar, works perfectly.

Community Browser