Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue in create master calendar

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.

5 Replies
its_anandrjs

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
Specialist
Specialist

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

its_anandrjs

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
Not applicable
Author

It's just type error.

Anonymous
Not applicable
Author

it's working fine now