topic Re: first 20 rows in Qlik NPrinting

first 20 rows

ilanbaruch — Wed, 25 Sep 2019 18:40:54 GMT

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

Re: first 20 rows

Lech_Miszkiewicz — Sun, 19 May 2019 23:39:40 GMT

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.

Re: first 20 rows

Henson20 — Thu, 23 May 2019 04:22:34 GMT

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