Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

FromDate, ToDate in Master Calender

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

17 Replies
Highlighted
Master
Master

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

Highlighted
Master II
Master II

if this solved your query please close the thread

regards

Pradosh

Learning never stops.
Highlighted
Master
Master

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

Highlighted
Master II
Master II

where exactly are you struck ?

Learning never stops.
Highlighted
Master
Master

in this issue

Highlighted
Master
Master

Thanks a lot Patil for your response and feedback

Highlighted
Master
Master

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

Highlighted
Master
Master

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

View solution in original post