Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Doc | Sum(Quantity) |
1 | -10 |
2 | 7 |
4 | 1 |
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.
Hi Patriciousa,
You can add the Quantity as a dimension in a filter pane.
Jordy
Climber