topic Re: Master calendar question in QlikView

Master calendar question

Sun, 13 Jul 2014 11:35:28 GMT

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

Re: Master calendar question

its_anandrjs — Sun, 13 Jul 2014 11:48:45 GMT

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.

Re: Master calendar question

its_anandrjs — Sun, 13 Jul 2014 11:54:03 GMT

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');

Re: Master calendar question

Sun, 13 Jul 2014 12:06:17 GMT

thanks for ur reply dude

Re: Master calendar question

its_anandrjs — Sun, 13 Jul 2014 14:24:16 GMT

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

Regards ,

Anand