Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dubey2
Partner - Contributor
Partner - Contributor

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

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. 

 

Labels (1)
1 Reply
Primrose
Contributor III
Contributor III

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.