Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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"} >}
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
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])
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