Dashboard

[prat121]

Hello all I wanted to know about something, I had a requirement where in the country filter if a particular country is chosen then the charts should not show any values related to that chosen country and should show all other results. 

[KGalloway]

I can think of two ways to do this, but there may be better ways.

1. Create a second field with all the same values as your country field called Country_Exclude or something like that. Then, add an if statement to your table on the Country dimension: if(Country <> Country_Exclude, Country). Then, uncheck "Include null values". This will only allow countries to show in the table if they are not the country selected in the Country_Exclude field. You can also do this in any charts that have a Country dimension.
   1. 
2. Make the selection of a single country in the country field and then select alternative.
   1. 

      This will select everything else and deselect your current selection.

Let me know if I can clarify anything.

[anat]

you can use -= or E ()

https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704#:~:text=The%20ans...