topic Limiting Rows in a Straight Table in QlikView

Limiting Rows in a Straight Table

Tue, 06 Dec 2011 06:09:58 GMT

Hi - this is probably a very newbie question, but I have a straight table that has over a million rows.

How can I limit the table to only show the top 1000?

Tue, 06 Dec 2011 06:51:39 GMT

Hi,

if you are using Straight table,go to "Presenation" tab there you can see radio button will help you to show no of

rows,it deponds on your "Expression" values. And also by using "Sort" tab you can select Top N "Max" or "Min"

values...

-Jen

Tue, 06 Dec 2011 07:08:16 GMT

Thanks - would you be able to help me with the code? Select top(1000) ... ?

See screen shot attached as well..

jagan — Tue, 06 Dec 2011 07:45:31 GMT

Hi,

The image you attached is using Table Box not a Straight Table. In Straight table you have the option of setting the number of rows to be displayed.

Regards,

Jagan.

Tue, 06 Dec 2011 07:57:57 GMT

Found it - thanks!

krishnaroopa — Thu, 21 Jun 2012 07:14:07 GMT

But the option available is to display only 1-100 records?

What is purpose of "Show others Row".

I have 10,00,000 and need to display in sets of 10000 with previous, next buttons,,, is it possible.

Thanks

KRS

Fri, 07 Aug 2015 14:01:15 GMT

Has anybody found a straightforward solution to this?

- for example, loading a table page by page, each page being x rows