Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 🙂

Tags (3)
Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Filter dimension in object FILTER PANE

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
Highlighted
Partner
Partner

Re: Filter dimension in object FILTER PANE

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

Highlighted
Creator III
Creator III

Re: Filter dimension in object FILTER PANE

Hi Stoyan_Terziev, 

 

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

Highlighted
Creator II
Creator II

Re: Filter dimension in object FILTER PANE

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