topic Re: Limit Straight Table Row in QlikView https://community.qlik.com/t5/QlikView/Limit-Straight-Table-Row/m-p/763831#M271500 <HTML><HEAD></HEAD><BODY><P>Try something like =sum(aggr(1, Dim1, Dim2, ..., DimN)) &lt; 10000 as calculation expression after replacing Dim1, Dim2, ..., DimN with the names of the dimensions in your chart. If you're using calculated dimensions you''ll have to add the dimensions used in the calculated dimensions.</P></BODY></HTML> Wed, 03 Dec 2014 10:26:19 GMT Gysbert_Wassenaar 2014-12-03T10:26:19Z Limit Straight Table Row https://community.qlik.com/t5/QlikView/Limit-Straight-Table-Row/m-p/763830#M271499 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I have problem with straight table. There are too many rows and column causing the object memory error.</P><P></P><P>May i know the way for me to limit the number of rows to be displayed as users are not keen to see all rows after they click clear all.</P><P></P><P>This is to prevent the object memory problem. I saw some ppl use calculation condition like count(id)&gt;10000. But it doesnt work for my straight table. Thank you</P></BODY></HTML> Wed, 03 Dec 2014 03:54:05 GMT https://community.qlik.com/t5/QlikView/Limit-Straight-Table-Row/m-p/763830#M271499 2014-12-03T03:54:05Z Re: Limit Straight Table Row https://community.qlik.com/t5/QlikView/Limit-Straight-Table-Row/m-p/763831#M271500 <HTML><HEAD></HEAD><BODY><P>Try something like =sum(aggr(1, Dim1, Dim2, ..., DimN)) &lt; 10000 as calculation expression after replacing Dim1, Dim2, ..., DimN with the names of the dimensions in your chart. If you're using calculated dimensions you''ll have to add the dimensions used in the calculated dimensions.</P></BODY></HTML> Wed, 03 Dec 2014 10:26:19 GMT https://community.qlik.com/t5/QlikView/Limit-Straight-Table-Row/m-p/763831#M271500 Gysbert_Wassenaar 2014-12-03T10:26:19Z