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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreasGu
Contributor II
Contributor II

Exclude value from dimension

I have a dimension called "Shipping country" which is being set as Master item. 

Currently that dimension include all countries available. However I would like to exclude a certain country from the list

 

=[Shipping country_id]

 

 Either if I can set a certain filter where I include it or could I just add some logic to the code above for the dimension. The country I would like to exclude is country code DE

Labels (1)
2 Replies
AlzhanNurtaza
Contributor III
Contributor III

Hey! 

You can use Wildmatch or match on master dimension, then on your chart "Supress zero values"

if(not(WildMatch(Country,'DE*')), Country)

 

AndreasGu
Contributor II
Contributor II
Author

Thank you. It works when I use the dimension as a filter. However I would like to add it to a summary,

More so it looks like attached: