Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
While limiting the dimension"Code" to the top 10 and sorting by Quantity desc, I get the exact 10 records in the Qlik sense app.
But when I filter the top 10 records in a pivot table, I get extra records because the bottom records have the same values.
How can I get the same thing in Qlik as well?
Below is my pivot table-
| Code | Quantity |
| 4H | 5 |
| 1I | 5 |
| 1P | 4 |
| 4W | 3 |
| 4P | 3 |
| 5O | 2 |
| 1Y | 2 |
| 1L | 1 |
| 1C | 1 |
| 1K | 1 |
| 1J | 1 |
| 4G | 1 |
Perhaps use Aggr(Code, Code) as condition
Can you tell me where should i use this condition?