Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rkondaveti
Contributor III
Contributor III

Out of object memory issue

  Hi all,

I am facing out of object memory issue in a chat wich has the following formula: is there a btter a to write this formula or any other way to overcome this error message . i am 10 SR3

IF

(GetFieldSelections(Year) = 2013,

(
if (sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) > sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome), 'qmem://<bundled>/BuiltIn/led_g.png',
if (sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) = sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome) and sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) >0 and sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome)>0, 'qmem://<bundled>/BuiltIn/led_o.png',
if ( sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) =0 and sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome)=0,0,'qmem://<bundled>/BuiltIn/led_r.png')))),


(
if (sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) > sum({<Year={"$(vPreviousYear)"}>} OperatingIncome), 'qmem://<bundled>/BuiltIn/led_g.png',
if (sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) = sum({<Year={"$(vPreviousYear)"}>} OperatingIncome) and sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) >0 and sum({<Year={"$(vPreviousYear)"}>} OperatingIncome)>0, 'qmem://<bundled>/BuiltIn/led_o.png',
if ( sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) =0 and sum({<Year={"$(vPreviousYear)"}>} OperatingIncome

)=0,0,'qmem://<bundled>/BuiltIn/led_r.png')))))

0 Replies