topic Re: Issue in create master calendar in QlikView

Issue in create master calendar

Anonymous — Mon, 15 Dec 2014 12:12:39 GMT

LET vStart = num('2014-01-01');

LET vEnd = num(('2014-01-01');

Master_Cal:

Load Date($(vStart) + RecNo(),'MM/DD/YYYY') as Date autogenerate $(vEnd) - $(vStart);

When I am excute this script for each month it's showing from 1st to 31st.

I dont understan why it's not get right month end date.

its_anandrjs — Mon, 15 Dec 2014 12:16:41 GMT

Hi,

Write this way and your End variable is wrong might be it is 2014-01-31

LET vStart = num('2014-01-01');

LET vEnd = num('2014-01-31');

Master_Cal:

Load

Date($(vStart) + RecNo(),'MM/DD/YYYY') as Date

autogenerate $(vEnd) - $(vStart);

Regards

Anand

saumyashah90 — Mon, 15 Dec 2014 12:17:18 GMT

How can you make start and end date as same????

its_anandrjs — Mon, 15 Dec 2014 12:24:42 GMT

Hi,

Or better you use

LET vStart = num('01/01/2014');

LET vEnd = num('12/31/2014');

Master_Cal:

Load

Date($(vStart) + RecNo()-1,'MM/DD/YYYY') as Date

autogenerate $(vEnd) - $(vStart);

Regards

Anand

Anonymous — Thu, 18 Dec 2014 14:20:38 GMT

It's just type error.

Anonymous — Thu, 18 Dec 2014 14:21:08 GMT

it's working fine now