Daily,Monthly Qvd's

qlikview979 — Wed, 16 Sep 2015 10:18:42 GMT

Hi Experts,

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

Re: Daily,Monthly Qvd's

manojkulkarni — Wed, 16 Sep 2015 10:43:55 GMT

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 — Thu, 04 Aug 2016 12:14:03 GMT

Hi All,

may be this is help full to others

'Daily & Monthly Qvd's

Regards