Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
joancasellasvega
Partner - Contributor III
Partner - Contributor III

Top 10 and Bottom 20

Hi,
I have the following expression:
count(INSTANCIA)/(count( distinct if( INSTANCIA > 0 , [LastModified.autoCalendar.Date])))
Which gives me the average number of "instanicas" made per day.
I would like to get the top 10 and bottom 20 in two different charts.
Any help will be really appreciated.
Thanks,
Joan

 

Labels (2)
1 Reply
TarekHajji
Contributor II
Contributor II

You can specify the top 20 or bottom 10 in the parameter of the chart
for example, in bar chart you can set the dimension limitation as fix number and specify the lower or bottom number
Regards11111.PNG