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?