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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
patriciousa
Creator II
Creator II

Filter pane - search for greater than, less, etc

Hi.

I have the following data.

DocQuantity
1-10
25
22
43
4-2
71

 

In my sheet in Qlik Sense, I have placed a table where:

DocSum(Quantity)
1-10
27
41

 

I want to add a Filter Pane to the sheet that allows me to search for specific results of Sum(Quantity), 

Example: search for documents exactly equal to 1 when sum(quantity)

The result visible in the table should only be "Doc 4"

Is this possible?

 

Thank you.

Regards.

1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi Patriciousa,

You can add the Quantity as a dimension in a filter pane.

Jordy

Climber

Work smarter, not harder