Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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.