topic Excluding date range in script in QlikView

Excluding date range in script

Thu, 17 May 2012 23:43:28 GMT

Hey,

We have around 7 years of data in our database and tring to reload it all causes Qlikview to slow up and crash. Currently Im using the option of "Always one selected value". But this isn't ideal as the other tabs require multiple dates, and the date sets are from a different field so it conflicts.

Here is a sample of the code that I have in the script for the receipt dates.

//BatchesLOAD Date(syscreated,'DD/MM/YYYY') as ReceiptDate,
    Date(MonthStart(syscreated),'MMM-YY') as MonthReceipted,
    text(Date(MonthStart(syscreated),'MMM')) as MthReceipted,
    Date(YearStart(syscreated),'YYYY') as YearReceipted,
    ItemCode as ReceiptCode,
    Number as Batch,
    syscreated as Receipted;
SQL SELECT
     ItemCode,
     Number,
    syscreated
FROM "009".dbo.ItemNumbers;

What could I add into the code so that it will only ever retrieve data from 2011 onwards?

Thank you.

Excluding date range in script

Anonymous — Fri, 18 May 2012 08:55:54 GMT

This depends a bit on your data format but you could try to add

Where Year(syscreated) > '2010' ;

So:

Where Year(syscreated) > '2010';

Let me know if this works for you.

Good Luck,

Dennis.

Re: Excluding date range in script

Sun, 20 May 2012 22:03:52 GMT

Thank you. This appears to have worked perfectly.