Hi.
I have the following data.
Doc | Quantity |
1 | -10 |
2 | 5 |
2 | 2 |
4 | 3 |
4 | -2 |
7 | 1 |
In my sheet in Qlik Sense, I have placed a table where:
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.