Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to filter the dimension?

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.

8 Replies
Not applicable

How to filter the dimension?

Hi Isaac ,

Try like this

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

put the above condition in the dimension ...

cabhijit
Valued Contributor

How to filter the dimension?

u can write the If condition as:

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

Not applicable

How to filter the dimension?

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.

danielrozental
Honored Contributor II

How to filter the dimension?

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.

Not applicable

How to filter the dimension?

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.

Not applicable

Re: How to filter the dimension?

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.

zygd_001
New Contributor II

Re: How to filter the dimension?

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.

VVJ
New Contributor II

Re: How to filter the dimension?

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()).