Community Corner

[jmialoundama]

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 🙂

[Stoyan_Terziev · Accepted solution]

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.

[jmialoundama]

Hi Stoyan_Terziev, 

Thanks you for your answer , its works perfectly for my dimension

[niha]

Hi,
Is your issues resolved? I think it can be done by set analysis. In the modifier, < dimension = {"15*"}>. This may help.