Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Filter dimension in object FILTER PANE

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 🙂

Labels (1)
  • Other

1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

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.

View solution in original post

3 Replies
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

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
Specialist
Specialist
Author

Hi Stoyan_Terziev, 

 

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

niha
Creator II
Creator II

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