Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master calendar question

Without "date" field in the table is there possibility to create a Master calendar ? , if So could u please tell me the script and scenario

1 Solution

Accepted Solutions
its_anandrjs

Why you do the script without the date field is there any reason behind that. But you have to use the date fields or NUM field value in the date field.

View solution in original post

4 Replies
its_anandrjs

Why you do the script without the date field is there any reason behind that. But you have to use the date fields or NUM field value in the date field.

View solution in original post

its_anandrjs

You can introduced the Num function and use NUM function for date values

LOAD

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

AutoGenerate 1

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

Not applicable
Author

thanks for ur reply dude

its_anandrjs

Thanks Manoj and welcome, If you got correct / helpful answer from the thread so mark the appropriate answer and close the thread.

Regards ,

Anand