FromDate, ToDate in Master Calender

[beck_bakytbek]

Hi Folks,

i have a question, Is there any technique or procedure, how to implement FromDate and ToDate in Master Calender to use as one Field?

Thanks a lot for any feedback and response

Beck

[beck_bakytbek]

Hi Pradosh,

thanks a lot for your feedback and response, i postet to this issue an another issue:

https://community.qlik.com/thread/277397

do you have any idea?

Beck

[pradosh_thakur]

if this solved your query please close the thread

regards

Pradosh

[beck_bakytbek]

if ithis solved, as matter of course i will do this

[pradosh_thakur]

where exactly are you struck ?

[beck_bakytbek]

in this issue

[beck_bakytbek]

Thanks a lot Patil for your response and feedback

[beck_bakytbek]

Hi Patil,

the Field: 'Close_Date' , what do you mean with Close_Date? Because i have only 2 Fields: FROMDATE and TODATE

Thanks a lot

Beck

[beck_bakytbek · Accepted solution]

Hi Folks,

i solved this issue by this way:

load date(FROMDATE + iterno() - 1) as DATE, [Amount] / (TODATE - FROMDATE) as DailyAmoount

from Source while FROMDATE + iterno() - 1 <= TODATE;

and after reload i do concatenate the Field: DATE with MasterCalender

i hope that helps

Beck