How to Show certain values in filter pane

[MPS]

Dear all,

Am trying to set certain value under the 'Filter Pane' with the below expression, but for some reason, it shows 'invalid dimension'.  Can you please help.

Dimension in filter pane --- =Only({<[Account Record Type]={'Consultant', 'ISA', 'Stakeholders'}>} [Account Record Type])

[Chanty4u · Accepted solution]

try this

aggr(Only({<[Account Record Type]={'Consultant', 'ISA', 'Stakeholders'}>} [Account Record Type]),[Account Record Type])

[Qlik1_User1]

@MPS  Try this

AGGR(Only({<[Account Record Type]={'Consultant', 'ISA', 'Stakeholders'}>} [Account Record Type]),[Account Record Type])

[MPS]

Thank you so much @Chanty4u  and  @Qlik1_User1  . Both worked perfectly 😊