topic How to filter the dimension? in QlikView

How to filter the dimension?

Wed, 30 Mar 2011 04:47:38 GMT

Hi All,

I have one field named 'Category' whose values are A,B and C.

Now I put it into Chart dimension, I don't want to show C in this dimension, how to filter it?

Thanks.

How to filter the dimension?

Wed, 30 Mar 2011 05:18:03 GMT

Hi Isaac ,

Try like this

=if(Category='A' or Category='B',Category)

put the above condition in the dimension ...

How to filter the dimension?

AbhijitBansode — Wed, 30 Mar 2011 05:25:00 GMT

u can write the If condition as:

IF(Category<>'C',Category,null())

How to filter the dimension?

Wed, 30 Mar 2011 06:07:37 GMT

Use If condition to sort this problem as stated above.

BUt if you taking it as an seperate filter you can also take a list box and use it.

How to filter the dimension?

danielrozental — Wed, 30 Mar 2011 17:03:13 GMT

You should do filters in expressions not in dimensions

sum({<Category-={'C'}>} Sales)

Will filter Category C without affecting performance as some of the suggestions here would.

How to filter the dimension?

Thu, 26 Apr 2012 14:31:46 GMT

What would happen if it has multiple category's like C, D, E, F. if you put filter on expression side, you will see one row for all these filters instead of a row per filter.

Re: How to filter the dimension?

Thu, 26 Apr 2012 14:32:00 GMT

What would happen if it has multiple category's like C, D, E, F. if you put filter on expression side, you will see one row for all these filters instead of a row per filter.

Re: How to filter the dimension?

Anonymous — Thu, 19 Apr 2018 05:39:03 GMT

I have used Count( {filter} Field) in my measure in bar chart.

The problem is that now I see empty columns in my graph which I wanted to filter out.

Re: How to filter the dimension?

VVJ — Fri, 21 Dec 2018 05:19:45 GMT

I used the expression IF(Category<>'C',Category) and able to filter the dimension without C.

Can you please let me know the use of ,null() here IF(Category<>'C',Category,null()).