This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!
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 🙂
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:
Dimensions would look like:
If(WildMatch([Code], '15*'), [Code], Null())
In QlikView you can have on-sheet-land trigger.
I hope that helps!
View solution in original post
Thanks you for your answer , its works perfectly for my dimension