first 20 rows

[ilanbaruch]

hi all

in my model i have a straight table with 1000+ rows

in my report i would want to present only the first \ last 20 rows

any ideas ?

advanced thanks

[Lech_Miszkiewicz · Accepted solution]

It is very unclear what you are trying to do.

Specify version of Qlik (View or Sense, which SR?), version of NPrinting you are working with

Are you talking about a raw table in your Qlik Model or are you talking about table object where you ususally have some sort of aggregation. Depending on your answers you could

• use dimension limits and use 2 objects (1 with top 20 and second with bottom 20)
• use a flag during load script to flag top 20 and bottom 20 records and use this flag as a filter.

to guide you more precisely we need precise description what you are trying to do.

[Henson20]

Load scripting with a flag worked for me...U can try that in yours..That could help solving your problem dqfansurvey