Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Daily,Monthly Qvd's

Hi  Experts,

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

2 Replies
manojkulkarni
Partner
Partner

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
Specialist
Specialist
Author

Hi All,

may be this is help full to others

'Daily & Monthly Qvd's

Regards