Skip to main content
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)