Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
janus2021
Creator
Creator

use group by in pie chart

Hi.

New question.

in a Pie chart i have as a dimension I have a field: PLANTS that show: sunflower, tulip, pine, oak etc and a measure showing sum (PLANTS ). Then the diagram shows all the different plants in percent. Is it possible to group / show ex: sunflower and tulip as one value ex flower and pine, oak as wood?

and also keep the summary correct.

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

Try using the Pick and Match combination:

Pick(Match(PLANTS,'sunflower','tulip','pine','oak'),'flower','flower','wood','wood')

View solution in original post

4 Replies
GaryGiles
Specialist
Specialist

Try using the Pick and Match combination:

Pick(Match(PLANTS,'sunflower','tulip','pine','oak'),'flower','flower','wood','wood')

janus2021
Creator
Creator
Author

Hi.

It works but i cant get i to work with sum(PLANTS), any tip how to make it work?

tresesco
MVP
MVP

Use the above expression as calculated dimension (expression) in your chart, and then your expression as is, i.e - sum(PLANTS)

janus2021
Creator
Creator
Author

Thanks.
Sometimes I'm blind to the most obvious things 🙂