Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kirankkk
Creator II
Creator II

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

kirankkk
Creator II
Creator II
Author

It's just type error.

kirankkk
Creator II
Creator II
Author

it's working fine now