topic Re: Need help translating frontend script to the data load script in App Development

Need help translating frontend script to the data load script

phiilip — Mon, 07 Apr 2025 10:23:31 GMT

The frontend script is as follows:

SUM(AGGR(((AVG(MeasureA * MeasureB) * SUM(MeasureC)) / MeasureB) * SUM(MeasureE), Dimension1, Dimension2))

I'm still pretty new to Qlik so I can't wrap my head around how I'm supposed to write this in the data load editor. I've tried so much yet nothing works...

Re: Need help translating frontend script to the data load script

Helga_W — Mon, 07 Apr 2025 10:45:09 GMT

Without knowing your data model and the definition of your measures it's hard to say whether the calculation of this formula can be done in the data model or not.

I assume that you are asking this question because the above formula is not very performant.

Using aggr function in chart expressions can be slow if the amount of data is huge.

In general to optimize UI performance, it's a good idea to pre-calculate as much as possible in the data load script. However if the fields that are underlying your dimensions and measures are spread over multiple tables in the data model, then it's likely that the formula cannot be calculated in the data model. Or only if you de-normalize your data model and/or do aggregations in the load script.

Re: Need help translating frontend script to the data load script

PrashantSangle — Mon, 07 Apr 2025 11:16:20 GMT

does all this fields are coming from one table? If not, then combine all table and make it in one table.

If yes, then try

Load Dimension1, Dimension2,

((AVG(MeasureA * MeasureB) * SUM(MeasureC)) / MeasureB) * SUM(MeasureE)

Resident TableName

Group By Dimension1, Dimension2;