Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
eri
Contributor III
Contributor III
Author

Can you tell me where should i use this condition?