Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

bmnpbmnpbmnp2
New Contributor

How do I categorise different values in the same field, and display that in a pie chart?

Assuming I have the following data:

https://i.imgur.com/k2ypx4D.png

How do I make it into a pie chart, combining NA and EU like this?

https://i.imgur.com/1IoJ2Aw.png

Thanks in advance

1 Reply
thiago_justen
Valued Contributor III

Re: How do I categorise different values in the same field, and display that in a pie chart?

Firstly you should create a calculated dimension in master item tab with the expression below.

Region:

If(Region='AS','AS','NA/EU')

Then you take pie chart with this:

Dimension - Region (created above)

Expression - Count(Region)

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
Community Browser