topic Generate calendar dates for a different field. in QlikView

Generate calendar dates for a different field.

agni_gold — Sat, 07 May 2016 17:25:07 GMT

Hi All ,

I have one field in a QVD ,

And i want to generate a calendar for each value in different field

Example : Suppose i have one field in QDV as Region and region has 2 values A and B

Now i want ot create all dates for A and B for 2 years.

and its should other table as REGION and DATE with two column.

How can i do this

swuehl — Sat, 07 May 2016 21:18:57 GMT

Maybe like

Let vStartDate = num(Today()); // or whatever defines the start of the two year period

NewTable:

LOAD DISTINCT Region as REGION

FROM YourQVD.qvd (qvd);

JOIN (NewTable)

LOAD Date( $(vStartDate) +Recno()-1) as DATE

Autogenerate Addyears($(vStartDate),2) - $(vStartDate) ;