Calculation timed out error in QlikView Pivot table.

[AS_A]

Hi, 

When I use below expression in Pivot table Dimension (calculated dimension) I'm getting Calculation Timed out error.

aggr(if(not IsNull(AgreementNumber), (AgreementNumber)),IndividualItemNumber)

Could you please help?

Thank you 🙂

[BrunPierre · Accepted solution]

Maybe

Aggr(Only({$<AgreementNumber = {"*"}>} AgreementNumber), IndividualItemNumber)

or

Aggr(Only({$<Field = {"=Len(Trim(Field))>0"}>} AgreementNumber), IndividualItemNumber)

[AS_A]

It worked. Thank you so much @BrunPierre 

[AS_A]

Hello @BrunPierre ,

Could you please help me to convert the below expression in to set expression? I need to optimize this so

AGGR(NODISTINCT(COUNT(DISTINCT(IF(L1>=2019401  AND (L2=1 AND (L3=1 OR L4>0)) AND (L5<>'M' AND L5<>'N'ANDL5 <>'O') ,IND_NUM)))), AGREEMENT_NUMBER)

Thank you:)

[BrunPierre]

=Count(DISTINCT {$<L1 = {">=2019401"}, L2 = {1}, L3 = {1} > + <L4 = {">0"}, L5-= {'M', 'N', 'O'}>} IND_NUM)

[AS_A]

Thanks,

But I'm not sure how to handle this Part   (L2=1 AND (L3=1 OR L4>0)  )

[BrunPierre]

'+' and '*' are used in place of the OR and AND operators respectively while combining two sets.

Have you tried the above?

or perhaps

=Count(DISTINCT {$<L1 = {">=2019401"}> * <L2 = {1}> * <L3 = {1} > + <L4 = {">0"}> * <L5-= {'M', 'N', 'O'}>} IND_NUM)