Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
yacine
Contributor II
Contributor II

Show only certain values in the donut chart

Hello everyone,

 

i want to only show only two specific values of a certain column in the donut chart. If we suppose that a column that is chosen as a dimension for a donut chart, contains six different values, then the six values will be show in the donut chart. However i only want three of them to be shown and the other three must be ignored. For the example of the chart below, three types of flavors are shown. What i want to do, is showing only strawberry and chocolate and ignoring vanilla.  How can i do this? thank u in advance.doughnut chart.png

Labels (4)
2 Replies
justISO
Specialist
Specialist

Hi, just define your flavors (3 certain values) in your percentage measure, something like:

Sum({<flavor = {'Strawberry', 'Chocolate', 'Vanilla'}>} [your_measure_field])

sidhiq91
Specialist II
Specialist II

@yacine  You can use the set analysis to resolve this issue.

As per your above requirement where you wanted to show only Strawberry and Chocolate:

Sum({<Flavor={'Strawberry ','Chocolate'}>}Amount)

This should resolve your issue.