4 Replies Latest reply: Jan 22, 2013 12:14 PM by Anne Duffy RSS

    Create a QVD When....

      Hi Experts

       

      I really hope you can help me out with this issue

      I am loading data in from Excel to Qlikview - but I now have a requirement for data as at a specific value dates - the third working day of the month !!

       

      I was going to try an create a QVD file only on the 3rd working day of the month and save it down with a variable name so I would have each of the Time values. But I am not sure how to script that where function

       

      Below is the very basic script I'm starting with - Any guidance would be greatly appreciated

       

      Thanks a mill

       

      A

       

      LET vFileDate = Date(Today(), 'YYYYMMDD');

       

      DailyData:
      LOAD *
      FROM [S:Qlikview\Tester\Incremental loads\Data.xls]
      (biff, embedded labels, table is Sheet1$);

      STORE DailyData INTO $(vFileDate).qvd (qvd);


      DROP TABLE DailyData;

      AllData:
      LOAD Date,
           Meat,
           Number
      FROM *.qvd (qvd);