Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ramya_grandhi
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

if(GetFieldSelections(Category)='TV',

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

l

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.

0 Replies