Skip to main content

Water Cooler

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!

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Creator III
Creator III

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
Creator III
Creator III
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.