How to show only some unique values of the column in a bar plot instead of all

dubey2 — Wed, 15 Feb 2023 11:32:30 GMT

In Qliksense, I have column in a dataset which has 5 unique values, let's say "A", "B", "C", "D" and "E". I have prepared bar plot which shows the bar plot of these 5 unique values. However, I want to show only 4 of them in the bar plot, i.e only "A", "B", "C", "D" and not all 5.

I cannot remove the 5th unique value from the data since that is used in other plot in the dashboard. How to use set expression to show only bars of 4 only instead of showing for all. The expression is this -

=if( varB='Mon',
sum({<Origin= {'temp1'}>}totalsum)/sum({<Origin= {'temp1'}>} totalprod),
sum({<Origin= {'temp2'}>}totalsum)/sum({<Origin= {'temp2'}>} totalprod))

This is the current set expression which is showing bars for each of the 5 unique values, but I want to show only for 4 of them.

Thank you.

Re: How to show only some unique values of the column in a bar plot instead of all

Primrose — Wed, 15 Feb 2023 11:54:30 GMT

Have you considered using -= operator in the set analysis? E.g. value-={'E'}. There are some nice threads here in the Community about set analysis. You can always refer to the documentation as well.

topic How to show only some unique values of the column in a bar plot instead of all in App Development

How to show only some unique values of the column in a bar plot instead of all

Re: How to show only some unique values of the column in a bar plot instead of all