Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikChick
Contributor II
Contributor II

Qlike Sense: Limit straight table to first 20 rows...

Morning! 

I have a straight table with about 400 rows, and I would like to display only the top 20 so employees can focus on those. Looks something like this (except several more columns):

ClientNameRevenue
10089Bob's Business80000
10087Pizza Shack60000
10074Car Parts Etc40000

 

I have it sorted by revenue, as we need to focus on higher revenue clients. What is the best way to do this? What expression would limit the rows. I have read through some options with firstsortedvalue, and something similar to this: if(rowno(total)<=20,Expression), but I can't get anything to work out.

Under the straight table options:

  • Under "Data", "Limitation" is grayed out
  • Under "Appearance" and "Presentation", I don't see any options to limit at all
  • I have Revenue as the first under the sort option
  • I am running Qlik Sense Enterprise, if that's any help

Please help me stop the madness-I've been staring at this and researching for far too long. 

Thanks!

Jenny

3 Replies
baliyan_vinay
Contributor III
Contributor III

Limiting the number of rows is generally done in Data Tab with 'Limitation' option but as you mentioned this is greyed out for you, maybe you can share the file. 

lironbaram
Partner - Master III
Partner - Master III

hi 

assuming Client and Client Name are dimensions and Revenue is a measure 

go to Client , under the field properties you'll find the limitation dropbox select fixed and set the number to 20

Annotation 2020-04-13 100713.png

mhenning
Partner - Contributor II
Partner - Contributor II

Just figured this out myself:

Column1 = dimension that you want to reduce

Column2 = measure: only(column 1 dimension).

 

Limit column 1 to top or bottom 10, it'll calculate on Column2 

hide Column2