topic QVD Creation in QlikView

QVD Creation

ashok1203 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a small requirement. Every month end i want create a month QVD for entire month and in current month i need to create a weekly QVD's and loads the data with previous months QVD. At end of the month Weekly QVDs has not been loaded i need to load only month end QVD. So i need this an automation.

Example: Now we are in September, 2016 (Current Month)

I want QVDs for September 1st to 4th

September 5th to 11th

September 12th to 18th

September 19th to 25th

and then month end QVD for entire month.The same i have to create every month (Current Month) automatically.

Please help on this....

Re: QVD Creation

giakoum — Tue, 27 Sep 2016 08:19:01 GMT

testTable:

LOAD * INLINE [

];

LET vWeekEnd = num(WeekDay(Today()));

LET vMonthEnd = MonthEnd(Today());

LET vToday = Today();

IF vWeekEnd = 6 or vMonthEnd = vToday then

STORE testTable into testTable$(vToday).qvd(qvd);

ENDIF

Re: QVD Creation

giakoum — Tue, 27 Sep 2016 13:00:35 GMT

Did it work for you?

Re: QVD Creation

ashok1203 — Wed, 28 Sep 2016 12:57:48 GMT

Thanks It's Working fine for me.

Re: QVD Creation

ashok1203 — Wed, 28 Sep 2016 12:58:01 GMT

Thanks It's Working fine for me.