topic Re: Limit number of rows in QlikView

Limit number of rows

shanky1907 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a straight table and i want to limit count of rows to a certain number and if the count of rows exceeds, it should show an error message.

Can anyone help how can i limit it at the first place.

Re: Limit number of rows

MarkWillems — Thu, 10 Oct 2019 10:55:39 GMT

I've done something similar where I count the rows and do and if statement within the Condition Show option, in layout, if has too many rows, it hides the table. So if you have one dimension you might use:

If(Count(DISTINCT DimensionA)<=20,1,0)

Using layering, you could hide a message underneath the object the only shows when the object is hidden.

If there are 20 or less rows for DimensionA then it will show the table, otherwise hide it showing the message underneath.

Re: Limit number of rows

Frank_Hartmann — Thu, 10 Oct 2019 11:15:38 GMT

like this:

Re: Limit number of rows

atoz1158 — Thu, 10 Oct 2019 11:23:01 GMT

The more standard way is to use the "Calculation Condition" on the General tab of the straight table chart properties to what ever you wish to use to limit the amount of rows available.

Then click the "Error Messages..." button also on the same tab and put a custom error message against the "Calculation condition unfulfilled" message.

Regards

Adrian

Re: Limit number of rows

MarkWillems — Thu, 10 Oct 2019 12:00:18 GMT

You're right, but the lack of control over the format of the error message means I never use it, I prefer the ability to use a tailor made text box instead.