Calculation Condition and System Functions

sjenkins — Fri, 20 Nov 2009 03:18:17 GMT

I am trying restrict users to only see a straight table if it returns less than 500 records. I have a Calculation Condition using getpossiblecount which works fine if the user makes restrictions based on various dimensions. However, one of the restrictions in the table is a calculated Dimension which is basically:

If sum(X)<50, null(),1) and then it suppresses the null rows.

This works properly to limit the rows in the table but the getpossiblecount still shows wider universe of records and thus the calculation condition fails.

Is there any way to do a calculation condition that counts the number of rows actually returned in the table?

Thanks,

Steve

Calculation Condition and System Functions

nathanfurby — Thu, 08 Sep 2011 16:58:33 GMT

In case anyone else stumbles upon this question as I did:

Resolved my issue by putting the following in the Calculation Condition field of the chart properties:

sum(AGGR(Count(PRODUCT_ID),TradeDate,Strategy))<50000

The PRODUCT_ID can represent any populated field in the table. TradeDate and Strategy are just the Dimensions in the chart in question. 50000 is obviously the row count limit for the chart table.

topic Calculation Condition and System Functions in QlikView

Calculation Condition and System Functions

Calculation Condition and System Functions