Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AdrianS1
Contributor III
Contributor III

Dimension in FilterPane

Hi guys, i have filter pane like this.

AdrianS1_1-1684332475546.png

I have dimension Merchant->Brand

I want to show the brands in filter brand but after a click on some merchants.

i have function like this:

If(Match(MERCHANT_NAME, (GetFieldSelections(MERCHANT_NAME))),BRAND)

but it works only for one merchant, when i click on few merchants, the brand is not showing.

Any idea for better function ?

I dont want to build a casual dimension because i can see a brand without clicking merchant.

Labels (3)
1 Solution

Accepted Solutions
Or
MVP
MVP

Perhaps something along the lines of:

If(GetSelectedCount(MERCHANT_NAME)>0,BRAND)

 

View solution in original post

1 Reply
Or
MVP
MVP

Perhaps something along the lines of:

If(GetSelectedCount(MERCHANT_NAME)>0,BRAND)