topic Qlike Sense: Limit straight table to first 20 rows... in App Development

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

QlikChick — Fri, 27 Mar 2020 14:24:46 GMT

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):

Client	Name	Revenue
10089	Bob's Business	80000
10087	Pizza Shack	60000
10074	Car Parts Etc	40000

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

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

baliyan_vinay — Mon, 13 Apr 2020 04:16:42 GMT

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.

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

lironbaram — Mon, 13 Apr 2020 07:08:16 GMT

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

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

mhenning — Fri, 01 Oct 2021 20:16:05 GMT

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