Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to filter the dimension?

Hi All,

I have field named 'Category' values red, yellow and green and maned 'Type' values high, middle and low.

Now I put it into Chart dimension, I don't want to show Type low in this dimension if Category is red, how to filter it?

2 Replies
Highlighted
Master III
Master III

Re: How to filter the dimension?

Hi Adrianus,

Sum({<Category-={'Red'}>+<Type-={'Low'}>} Value)

or

Sum(If(Category <> 'Red',Value,If(Type <> 'Low',Value)))

Regaards,

Antonio

Highlighted
Contributor
Contributor

Re: How to filter the dimension?

Thank you Antonio,

I'll try your formula and inform you the result...