Discussion board for questions about the Qlik Community Platform as well as general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!
Hello,
I have a dimension that contains several codes. I want to filter only codes starting with 15.
I know that it is possible to perform the filtering in the loading script but I use this dimension in other sheets. That's why I want to filter in the sheet instead of the script.
Thank you in advance 🙂
Hello,
If you are talking about Qlik Sense, that would normally require to use set expression or if-statement in your Dimension or Measures. Best practice is to have them as separate master items.
Measures would look like:
Count({<[Code]={"15*"}>} Number)
Dimensions would look like:
If(WildMatch([Code], '15*'), [Code], Null())
In QlikView you can have on-sheet-land trigger.
I hope that helps!
Kind regards,
S.T.
Hello,
If you are talking about Qlik Sense, that would normally require to use set expression or if-statement in your Dimension or Measures. Best practice is to have them as separate master items.
Measures would look like:
Count({<[Code]={"15*"}>} Number)
Dimensions would look like:
If(WildMatch([Code], '15*'), [Code], Null())
In QlikView you can have on-sheet-land trigger.
I hope that helps!
Kind regards,
S.T.
Hi Stoyan_Terziev,
Thanks you for your answer , its works perfectly for my dimension