topic Re: Calculation timed out error in QlikView Pivot table. in QlikView

Calculation timed out error in QlikView Pivot table.

AS_A — Fri, 15 Nov 2024 21:12:57 GMT

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 — Mon, 11 Dec 2023 11:54:55 GMT

Maybe

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

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

AS_A — Mon, 11 Dec 2023 13:04:49 GMT

It worked. Thank you so much @BrunPierre

AS_A — Thu, 14 Dec 2023 13:43:06 GMT

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 — Thu, 14 Dec 2023 18:05:45 GMT

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

AS_A — Fri, 15 Dec 2023 05:38:56 GMT

Thanks,

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

BrunPierre — Fri, 15 Dec 2023 06:42:33 GMT

'+' 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)