Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN 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.

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