2 Replies Latest reply: May 20, 2012 6:03 PM by John Reardon RSS

Excluding date range in script

John Reardon

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
    Dennis Hoogenboom

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

     

    Where Year(syscreated) > '2010' ;

     

    So:

     

    //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

    Where Year(syscreated) > '2010';

     

    Let me know if this works for you.

     

    Good Luck,

    Dennis.