Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.