Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot table expression in load script

The formula below is being used in a pivot table. I think it is the main reason for 'exceeded allocated memory' and 'object out of memory'.

I want to implement this expression in the script. vR1 and vStoreRole are the variables being used in the formula.

SignFlag gives 0 if it is null and 1 if it is not

Table used for Role and RoleID. Multiple 'Role' are selected from the listbox using checkboxes to be used in the formula

Role RoleID

Manager 1

Specialist 2

Partner 3

Staff 4


(Num(Aggr(Count({<RoleID = {"$(vR1)","$(vR2)","$(vR3)","$(vR4)"}>} Distinct SubphaseReference), EngagementKey)


Aggr(Count({$<SignoffFlag -={""}>} Distinct SubphaseReference),EngagementKey) *100,0) )

=-1, 0,

Num(Aggr(Count({<RoleID = {"$(vR1)","$(vR2)","$(vR3)","$(vR4)"}>} Distinct SubphaseReference), EngagementKey)


Aggr(Count({$<SignFlag -={""}>} Distinct SubphaseReference),EngagementKey)







vStoreRole=Concat(Distinct RoleID,',')

0 Replies