Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eri
Contributor III
Contributor III

Top 10 values

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-

CodeQuantity
4H5
1I5
1P4
4W3
4P3
5O2
1Y2
1L1
1C1
1K1
1J1
4G1
Labels (1)
2 Replies
Anil_Babu_Samineni

Perhaps use Aggr(Code, Code) as condition

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
eri
Contributor III
Contributor III
Author

Can you tell me where should i use this condition?