topic Restrict date data returned in script in QlikView

Restrict date data returned in script

Thu, 12 Mar 2015 16:28:32 GMT

I want to restrict the amount of data visible in the report as it cannot handle all the historic data and returns an error, 'Out of Object Memory'.

I only want to show data from 2013 onwards as that is all that is relevant in this report.

My script looks like this:

How would I go about restricting the year(InvoiceDate) as Year to 2013 onwards.

I have a list box for Year on the report and at the moment it goes back to 1996.

I'm sorry I can't post the qvw as it has information regarding our customers, their products and quantities sold.

Thanks Steve

Thu, 12 Mar 2015 16:50:42 GMT

Hi Steve,

you would just need to add an additional where condition to the load.

AND Year(InvoiceDate)>=2013

hope that helps

Joe

MK_QSL — Thu, 12 Mar 2015 16:51:48 GMT

Invoice:

Load

From FileName

Where ProductCode <> 'PBLUE' and Year(InvoiceDate) >= 2013;

Thu, 12 Mar 2015 16:56:28 GMT

Hi Joe

Thanks, I tried something similar but I must of got the syntax wrong.

Steve

Thu, 12 Mar 2015 17:00:27 GMT

No worries, glad to help