Qlik Sense Filter Pane : Exclude Few Dimension

[Purushothaman]

Hi there,

In the Filter Pane, How to exclude few dimension ? I need to exclude Hyundai, Mazada and Toyota from list. How to do it?

Anyone, Please Help!!

Thank you!!

[vinieme12 · Accepted solution]

LIKE BELOW

  Aggr(Only({<ProductGroup-={'MAZDA','TOYOTA'}>}ProductGroup), ProductGroup)

[Purushothaman]

Hi @vinieme12 ,

Thank your response. Where should I type this expression? Please help. Thank you!

[vinieme12]

In the highlighted box,

Replace DIMENSION "PRODGROUP"  with a Calculated Dimension

=  Aggr(Only({<ProductGroup-={'MAZDA','TOYOTA'}>}ProductGroup), ProductGroup)

[Purushothaman]

Thank you for your timely help!! Much Appreciated.