Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
ziabobaz
Contributor III

Show only certain Dimensions in a Filter pane

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])

Tags (4)
1 Solution

Accepted Solutions

Re: Show only certain Dimensions in a Filter pane

More like this

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

View solution in original post

5 Replies

Re: Show only certain Dimensions in a Filter pane

More like this

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

View solution in original post

Highlighted
ziabobaz
Contributor III

Re: Show only certain Dimensions in a Filter pane

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

Highlighted

Re: Show only certain Dimensions in a Filter pane

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?

Highlighted
ziabobaz
Contributor III

Re: Show only certain Dimensions in a Filter pane

3.1 SR4 - the recent version

NOT resolved yet =(

Highlighted

Re: Show only certain Dimensions in a Filter pane

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