Out of Calculation Memory error in Straight Table

ramya_grandhi — Thu, 25 Oct 2018 12:48:39 GMT

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

if(GetFieldSelections(Category)='TV',

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

if(GetFieldSelections(Category)='Laptop',

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

if(GetFieldSelections(Category)='Desktop',

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.

topic Out of Calculation Memory error in Straight Table in App Development

Out of Calculation Memory error in Straight Table