topic Re: Allocated memory exceeded - error in QlikView

Allocated memory exceeded - error

Rkota — Thu, 01 Dec 2016 22:00:48 GMT

Hi - Would appreciate any help in understanding the error I mentioned in the subject line when I try to run this statement

Sum({<InvoiceDate ={">=$(=date(MonthStart(AddMonths(Today(),-14))),'MM/DD/YYYY HH:MM')">}[Line Item Amount])

Thanks a ton

Re: Allocated memory exceeded - error

vishsaggi — Thu, 01 Dec 2016 22:07:13 GMT

Try this

Your Expr:

Sum({<InvoiceDate ={">=$(=date(MonthStart(AddMonths(Today(),-14))),'MM/DD/YYYY HH:MM')">}[Line Item Amount])

Changed Expr:

Sum({<InvoiceDate ={">=$(=date(MonthStart(AddMonths(Today(),-14)),'MM/DD/YYYY HH:MM'))">}[Line Item Amount])

Re: Allocated memory exceeded - error

Rkota — Thu, 01 Dec 2016 22:13:06 GMT

Thanks for the suggestion Vishwarath....unfortunately it didn't work I even tried removing the / and : in the date format....and it didn't go anywhere

Re: Allocated memory exceeded - error

vishsaggi — Thu, 01 Dec 2016 22:23:46 GMT

Did you try taking off the Timestamp and just used the date format? Is your InvoiceDate format is same as the format 'MM/DD/YYYY' ?

Can you share your sample app you are working on to further look into it?

Re: Allocated memory exceeded - error

Rkota — Thu, 01 Dec 2016 22:31:21 GMT

Yes I did....however didn't help..

I'll try to pare down the data ..right now it has 2 years worth of data that may be too much and cannot share

thanks for your help

Re: Allocated memory exceeded - error

Rkota — Thu, 01 Dec 2016 23:13:07 GMT

Here's the correct expression....The >= expression was incorrect..I.E the = and > need to be separated..together they were possibly causing an overflow...

Sum({<InvoiceDate = {"$(='>' & Date(MonthStart(Today(), -13), 'YYYY-MM-DD'))"}>} [Line Item Amount])

Thanks to Sunny T's post on another thread..

------------------------------------

Sunny T Aug 17, 2016 8:13 AM (in response to Mikko Sippola)

How about this:

Sum({<date = {"$(='>' & Date(WeekStart(Today(), -1), 'YYYY-MM-DD'))"}>} sales)

Also read here about Dates in Set Analysis

-----------------------------------

Re: Allocated memory exceeded - error

vishsaggi — Thu, 01 Dec 2016 23:26:34 GMT

Sounds good. Dates in set analysis is quite sensitive, so usually miss things like this. Glad you figured it.

Re: Allocated memory exceeded - error

Rkota — Thu, 01 Dec 2016 23:29:48 GMT

as a Qlik rookie....am experiencing the "sensitiveness" of Qlik, rather painfully...LOL

all good though