Daily,Monthly Qvd's

[qlikview979]

Hi  Experts,

How to create the DAILY & MONTHLY QVD'S  by using script ? Explain with Example ?

[manojkulkarni]

follow same for year & qtr

LET vcurrentdate= num(MonthStart(AddYears(num(Today()),-3))); // Set start date

DO WHILE vcurrentdate <= Today()

  ExportSales:

  NOCONCATENATE

  LOAD *

  RESIDENT Sales

  WHERE InMonth(Date, $(vcurrentdate), 0) = true();

  LET vdatestring = Date($(vcurrentdate), 'YYYY_MMM');

//  STORE Sales INTO (qvd); // Your export file name
  STORE ExportSales INTO [.\$(vdatestring).QVD] (qvd); // Mine

  DROP Table ExportSales;

  LET vcurrentdate = num(AddMonths($(vcurrentdate), 1));

LOOP

[qlikview979]

Hi All,

may be this is help full to others

'Daily & Monthly Qvd's

Regards