Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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: