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 😊

[cjgorrin]

This is what I normally do, @jchan . Unfortunately it messes up the order and color of the elements in the filter pane. I was wondering if nowadays in 2025 there is a better way to do this. So far, the only way I have found to work 100% as expected is cloning the field but putting Null() instead of the values we don't want in the filter pane and then using that field.