Filter panel. Display certain values.

[Magogar]

Hello.

I want certain values ​​to be displayed in the filter panel, so I apply the following expression:

=if(city='VALENCIA',desc_prod_acu_cd&' | '&producto_acu_cd)

The problem is that this criterion is also applied in the calculation of the visualization measurements. I only want to select one city, but I don't want it to affect the calculation for other cities.

Thanks.

[Magogar · Accepted solution]

Solved!

=Aggr(
Only({< flag_cd ={"VALENCIA"} >} desc_prod_acu_cd)
,desc_prod_acu_cd)

https://community.qlik.com/t5/New-to-Qlik-Analytics/Exclude-Values-in-a-Filter/td-p/2451270

Thanks to @rwunderlich