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: 
Nolgath
Creator
Creator

Top 10 results in a table

Hello, I have this expression measure : 

 

COUNT({<vehicleStatus={0}>} dealer)

 

I need to get  table with top 10 values from the measure COUNT({<vehicleStatus={0}>} dealer).

I have in this table fields 'dealer' , 'address',  'phone', 'online cars or (COUNT({<vehicleStatus={0}>} dealer))'

 

How can i do so that it gives me top 10 dealers with highest 'COUNT({<vehicleStatus={0}>} dealer)' values?

 

Appreciate your help!

Labels (5)
1 Solution

Accepted Solutions
Mark_Little
Luminary
Luminary

Hi 

With in the options, find your dealer dimension. Change the limitation drop down to Fixed number and it should automatically be set to set to ten. 

mark6505_0-1672742351651.png

 

View solution in original post

2 Replies
Oliver_F
Partner - Creator III
Partner - Creator III

Hi,

have you tried this in the properties panel:

1) Qlik on Dimension

2) Select in the limitations dropdown: fix numbers => Top 10

 

I attached a screenshot. Unfortunately it is in german, but you can probably identify the values.

 

 

Mark_Little
Luminary
Luminary

Hi 

With in the options, find your dealer dimension. Change the limitation drop down to Fixed number and it should automatically be set to set to ten. 

mark6505_0-1672742351651.png