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: 
evansabres
Specialist
Specialist

Chart / Table / List of Top Items

Hello -

I have an application for restaurant sales. I have a dimension called [Major Group] that has fields such as 'Food' and 'Beer' and 'Liquor' and 'Wine'

I have another dimension called [Family Group] that has fields such as 'Burgers' and 'Draft Beer'

Finally, I have another dimension called [Menu Item] that has the specific menu item names 'Cheesburger' etc.

I have created a drill-down group that has the above hierarchy.

I want to either create a table or chart that displays the top 5 items from each Group if possible by sales [Total Sales] or volume [Sales Count]

Is there an efficient way to do this?

1 Solution

Accepted Solutions
nico_ilog
Partner - Creator II
Partner - Creator II

Hi Evan,

Are you using QV or QSense?

Either Way its quite easy.

1. Create your drill down group.[Major Group - Family Group - Menu Item]

2. Use it as the dimension

3. Set the measure to Sum([Total Sales])

4. This is the important part --> Set your Limitations to show top 5 values only (see attached)

QSense.JPG


QView.JPG


Let me know if it works.


Nico

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Major Group - Family Group - Menu Item

TOP 5 means TOP 5 from Menu Item

or

TOP 5 Major Group's TOP 5 Family Group's Top 5 Menu Item?

evansabres
Specialist
Specialist
Author

Top 5 Menu Items within the Major Group.

So, if I pick 'Food' from my [Major Group] I want to see the top 5 items ([Menu Item]) from that.

Ultimately, I want to include this in a Qlikview report

MK_QSL
MVP
MVP

Can you provide sample data in excel file to work?

If possible, also include the expected result you are looking for.

I would like to work on this!

nico_ilog
Partner - Creator II
Partner - Creator II

Hi Evan,

Are you using QV or QSense?

Either Way its quite easy.

1. Create your drill down group.[Major Group - Family Group - Menu Item]

2. Use it as the dimension

3. Set the measure to Sum([Total Sales])

4. This is the important part --> Set your Limitations to show top 5 values only (see attached)

QSense.JPG


QView.JPG


Let me know if it works.


Nico