topic Monthly calendar in QlikView

Monthly calendar

Tue, 03 Nov 2015 14:00:29 GMT

Good morning friends,

I'm try to create a Monthly calendar based on date field (in this case called Fecha) but i can't. The problem is with "MakeDate", so is not possible to send Month Number in a variable.

Can any one help me please?

Thanks in advanced.

My script:

LOAD * INLINE [

Fecha

30-10-2015

];//

Mes_limites:

load MonthStart(Fecha) as MinDate,

MonthEnd(Fecha) as MaxDate

Resident TMP;

LET vMonth = num(Month( Peek('MinDate',0,'Mes_limites')));

LET vMaxDay = num(Day(vMaxDate));

Load Date(RecNo()-1+MakeDate(2015,"&(vMonth)")) as Date Autogenerate $(vMaxDay);

Re: Monthly calendar

Gysbert_Wassenaar — Tue, 03 Nov 2015 14:11:01 GMT

Maybe like this:

LOAD Monthstart(Date)+Iterno()-1 as Date

While Monthstart(Date)+Iterno()-1 <= MonthEnd(Date);

LOAD date#(Fecha,'DD-MM-YYYY') as Date INLINE [

Fecha

30-10-2015

];

Re: Monthly calendar

Tue, 03 Nov 2015 14:54:51 GMT

Great gwassenaar

Works fine, thanks!!!