topic Re: Aggr expression in load script in QlikView

Aggr expression in load script

Anonymous — Mon, 03 Apr 2017 19:23:10 GMT

I want to implement the Pivot Table calculated dimension below in load script. I tried but could not. The pivot table was giving the 'allocated memory exceeded' error. Can somebody help me?

Num(Aggr(Count({<ERIDForFilter = {"$(vER1)","$(vER2)","$(vER3)","$(vER4)"}>} Distinct SubphaseNumber_vwSO), EngagementFile)

Aggr(Count({$<SignoffFlag -={""}>} Distinct SRNForFilter),EngagementFile)

*100,0)

Variables:

vER1 = SubField(vStoreEngagementRole,',',1)

vER2 = trim(SubField(vStoreEngagementRole,',',2))

vER3 = trim(SubField(vStoreEngagementRole,',',3))

vER4 = trim(SubField(vStoreEngagementRole,',',4))

vStoreEngagementRole = Concat(Distinct ERIDForFilter,',')

Re: Aggr expression in load script

hector_munoz — Mon, 03 Apr 2017 19:46:30 GMT

Hi Ranajit,

Everything is based in user selections:

vStoreEngagementRole = Concat(Distinct ERIDForFilter,',') are possible values (availables after some field selections),

vER1, vER2, vER3 and vER4 are the first 4 possible values

Why do you want you calculate the expression in script?

Regards,
H

Re: Aggr expression in load script

Anonymous — Mon, 03 Apr 2017 20:17:22 GMT

I wanted to calculate the expression in script because this expression is a calculated dimension in the pivot table because I assume it is giving me the 'Allocated Memory Exceeded' and 'Out of object' errors. There are 3 other dimensions - all single fields.

In the Expressions, there are 9 expressions with calculations in Conditional and Definitions. Each expression represents an image that will show individual or multiple images depending on user selections.

Since there is only 1 Calculated Dimension, I assumed from my research in QV discussions and blogs, that this is most likely causing the error and implementing it in script and passing a field into the pivot table would fix the error.

Any thoughts on this?

Re: Aggr expression in load script

Anil_Babu_Samineni — Tue, 04 Apr 2017 05:38:13 GMT

You may send application so then we came to know what you would and what changes you need

Re: Aggr expression in load script

Kushal_Chawda — Tue, 04 Apr 2017 07:44:02 GMT

this expression looks like, giving % values, why not to move it in expression instead of calculated dimension?

Re: Aggr expression in load script

Anonymous — Thu, 27 Apr 2017 18:57:13 GMT

I resolved the issue. It was a field in the Expressions giving all values instead of selected values. I appreciate all you replies and help