Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Filtering members in Dimension

In Qlik Sense Dimension how to filter specific values to show up in simple table.Ex: I have 4 product types as A,B,C,D and want to show only A&B with its corresponding measures  in a table without using the column filter.Thanks.

1 Solution

Accepted Solutions
MVP
MVP

Re: Filtering members in Dimension

Hi,

Try this expression

=Sum({<ProductType={'A', 'B'}>} MeasureName)

This will display only ProductType  A and B.

If you have multiple expressions in your chart then you have use this part of expression in all expressions.

{<ProductType={'A', 'B'}>}

Regards,

Jagan.

2 Replies
MVP
MVP

Re: Filtering members in Dimension

Hi,

Try this expression

=Sum({<ProductType={'A', 'B'}>} MeasureName)

This will display only ProductType  A and B.

If you have multiple expressions in your chart then you have use this part of expression in all expressions.

{<ProductType={'A', 'B'}>}

Regards,

Jagan.

Not applicable

Re: Filtering members in Dimension

Thanks Jagan!!

Community Browser