Filtering members in Dimension

[#1]

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.

[jagan · Accepted solution]

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.

[#3]

Thanks Jagan!!