Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
eri
Contributor III
Contributor III
‎2019-11-22 07:44 AM

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)
Labels
1,245 Views
0 Likes
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2019-11-22 08:04 AM

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
1,231 Views
0 Likes
eri
Contributor III
Contributor III
‎2019-11-22 08:29 AM
Author

In response to Anil_Babu_Samineni

Can you tell me where should i use this condition?

1,222 Views
0 Likes