topic Limit the count of rows displayed in QlikView

Limit the count of rows displayed

Black_Hole — Sat, 16 Nov 2024 01:07:30 GMT

Hello all,

I would like to limit to 100 000 the number of rows displays in a straight table.

Please could you tell me how can I do that in a straight table.

Thank you in advance for your help.

Re: Limit the count of rows displayed

jochem_zw — Thu, 05 Mar 2020 20:48:54 GMT

You can use the calculation condition but this will only show the table when count of records <100.000, so put an expression like count(....)<100000. You can also edit the message when calculation is not fullfilled

Re: Limit the count of rows displayed

Brett_Bleess — Thu, 02 Apr 2020 12:55:08 GMT

Perhaps the Dimension Limits tab settings of the Straight Table:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Straight_Table.htm

Click the Char Properties: Dimension Limits on the right side to drop to that section directly.

Regards,
Brett