Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master calendar Error

Master calendar Error ...... could u please explain me the script error and if possible give me a possible script

3 Replies
its_anandrjs

Try to load your script like

Let varMin = Num(Date#('01-01-2014','MM-DD-YYYY'));

Let varMax = Num(Date#('07-13-2014','MM-DD-YYYY'));

LOAD

date($(varMin)+IterNo()-1) AS Date

AutoGenerate 1

WHILE $(varMin)+IterNo()-1<= $(varMax);

its_anandrjs

And for your script that you use right now make some changes convert the input date values into the dates then it works fine see the load script

LOAD

Date(Date#('01-01-2014','MM-DD-YYYY') + IterNo()-1) AS Date

AutoGenerate 1

WHILE  Date#('01-01-2014','MM-DD-YYYY') + IterNo()-1 <= Date#('07-13-2014','MM-DD-YYYY');

its_anandrjs

And there is one more way of doing the same but with NUM function

LOAD

Date( Num('01/01/2014') + IterNo() - 1) AS Date

AutoGenerate 1

WHILE  Num('01/01/2014') + IterNo() - 1 <= Num('07/13/2014');

Hi Manoj,

Without closing any thread do not open the new thread which is similar to the question until that completes just a suggestion for you look the below thread and close if got correct or helpful.

Master calendar question | Qlik Community

Regards

Anand