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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bruce_Wang
Contributor
Contributor

how to fix value for filter pane in QlikSense

 

Example:

Dimension: Product

Value: Product A

              Product B

              Product C

                 .

                 .

                 .

             Product X

When I create a Filter Pane with dimension Product, I want the value only show Product A and Product B. does this possible?

Labels (1)
1 Solution

Accepted Solutions
siddharth_s3
Partner - Creator II
Partner - Creator II

If you want to hardcode, then:

 

AGGR(ONLY ({<Product={'Product A','Product B'}>} Product), Product)

View solution in original post

1 Reply
siddharth_s3
Partner - Creator II
Partner - Creator II

If you want to hardcode, then:

 

AGGR(ONLY ({<Product={'Product A','Product B'}>} Product), Product)