Exclude Values in a Filter

[quickqlik2]

I've got a table that tracks sales across various stores and regions. One of my filters is on the "Store ID". I want to exclude the following three values from my "Store ID" filter:

1. "280-NEI hidden"
2. "414-XUE hidden"
3. "783-VTO hidden"

I can't exclude these in the data load, I have to do it with set analysis. I've tried this but I get an "Expression error" error when writing the "Store ID" filter function in the listbox properties:

={< [Store ID] -={"280-NEI hidden", "414-XUE hidden", "783-VTO hidden"} >}

[marksouzacosta]

Hi @quickqlik2,

Set Expressions only work with Measures.

I personally don't like this, but you can create this calculated Dimension:

If(Not Match([Store ID],'280-NEI','414-XUE','783-VTO'),[Store ID])

[rwunderlich · Accepted solution]

Your set needs to be in an aggregation function, eg Only(). Try this:

=Aggr(
Only({< [Store ID] -={"280-NEI hidden", "414-XUE hidden", "783-VTO hidden"} >} [Store ID])
,[Store ID])

-Rob