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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajitha1
Contributor III
Contributor III

How to retrieve top 5 products from each sub-category in each category

how to retrieve top 5 products from each sub-category wise as well as each category wise

Labels (2)
1 Solution

Accepted Solutions
Tanish
Partner - Creator
Partner - Creator

Hi @Rajitha1 ,

Let me tell you the simplest way.

1. Create a Pivot Table 

2. Add your fields - Category , Sub-Category , Product , Sales

3. Under Product tab set limitation as 5 or you can make it dynamic as well through Variable input.

Attaching the screenshot as well for your reference.

Tanish_0-1695279214748.png

Hope this will help.

 

View solution in original post

3 Replies
Tanish
Partner - Creator
Partner - Creator

Hi @Rajitha1 ,

Let me tell you the simplest way.

1. Create a Pivot Table 

2. Add your fields - Category , Sub-Category , Product , Sales

3. Under Product tab set limitation as 5 or you can make it dynamic as well through Variable input.

Attaching the screenshot as well for your reference.

Tanish_0-1695279214748.png

Hope this will help.

 

Rajitha1
Contributor III
Contributor III
Author

Hi Tanish,

Thank you

Tanish
Partner - Creator
Partner - Creator

Hi @Rajitha1 , 

If solution is right, please mark it as Solved. It would be helpful for others to refer.