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.