Show only certain Dimensions in a Filter pane

[ziabobaz]

hi

I have Category dimension and Product dimension.

Each product is assigned with one category

In the filter pane, I want to show only those products, which belong to certain categories.

I use the following formula, but it does not work, please help

aggr({<[Category]={'ABC'}>} [Product],[Product])

[sunny_talwar · Accepted solution]

More like this

Aggr(Only({<[Category]={'ABC'}>} [Product]), [Product])

[ziabobaz]

I just noticed that the field search is no longer working in the filter pane.

[sunny_talwar]

Yes, this is a qlik sense related issue where calculated measures for filter pane doesn't allow for searching. It might have been resolved in the latest version. Are you using the most recent version of Qlik Sense?

[ziabobaz]

3.1 SR4 - the recent version

NOT resolved yet =(

[sunny_talwar]

I saw someone mentioning that there is SR5 where it might have been resolved. May be it is only available to partners right now? I don't know