Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Out of Calculation Memory error in Straight Table

Hi All,

I am new to Qlik Sense and I have an urgent requirement as follows

A straight table with 16 columns out of which 11 columns are dimensions and 5 columns are calculated measures.

Measure Expression is as below


sum({$<OrderYear = {$(=max(OrderYear))}, OrderMonth = {"<=$(=max({<OrderYear={$(=max(OrderYear))}>} OrderMonth))"}>} Sales*1)/1000,



sum({$<OrderYear = {$(=max(OrderYear))}, OrderMonth = {"<=$(=max({<OrderYear={$(=max(OrderYear))}>} OrderMonth))"}>} Sales*2)/1000,


sum({$<OrderYear = {$(=max(OrderYear))}, OrderMonth = {"<=$(=max({<OrderYear={$(=max(OrderYear))}>} OrderMonth))"}>} Sales*1)/1000)))

Now my straight table is throwing "Out of Calculation Memory error". So, I am trying to load the expression into a variable in the load script but I have no idea on how to do this.

Can someone suggest me how to load this expression into a variable in the load script and then call that variable in the measure in the straight table.

0 Replies