topic Re: FromDate, ToDate in Master Calender in Visualization and Usability

FromDate, ToDate in Master Calender

beck_bakytbek — Mon, 09 Oct 2017 20:26:06 GMT

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

Re: FromDate, ToDate in Master Calender

MK9885 — Mon, 09 Oct 2017 20:48:06 GMT

if([Effective Date]>='05/01/2014' and [Effective Date]<='08/01/2015' ,[Effective Date]) as NewDate

This would give dates only in between above dates.

Is that what you looking for?

If date field is defined then probably do preceding load?

Load*,

if([Effective Date]>='05/01/2014' and [Effective Date]<='08/01/2015' ,[Effective Date]) as NewDate;

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 09:04:24 GMT

Hi Aehman,

first of all thanks a lot for your response,

i am looking for the procedure, where i can implement the Fields: FROMDATE, TODATE into Mastercalender as one Field.

Do you have any ideas or technique to solve this issue?

Beck

Re: FromDate, ToDate in Master Calender

Anonymous — Tue, 10 Oct 2017 09:14:24 GMT

Try this procedure to create dates between "FROMDATE" and "TODATE"

Temp_Date_Range:

LOAD

num(Min(DATE("Close_Date"))) as FromDate,

num(Max(DATE("Close_Date"))) as ToDate

Resident Data_Table;

LET vMinDate=Peek('FromDate',0,'Temp_Date_Range');

LET vMaxDate=Peek('ToDate',0,'Temp_Date_Range');

drop table Temp_Date_Range;

MasterCalender:

LOAD DISTINCT

$(vMinDate) +IterNo()-1 as Temp_Date

AutoGenerate(1)

while IterNo()+$(vMinDate)-1<=$(vMaxDate);

Regards

Sahadev

Re: FromDate, ToDate in Master Calender

jonathandienst — Tue, 10 Oct 2017 09:33:57 GMT

FromDate and ToDate are probably not best represented as fields in the calendar. They are usually implemented in variables, whicj you can then use in set expressions and calculated dimensions.

Perhaps you could explain exactly what end result you are pursuing?

Re: FromDate, ToDate in Master Calender

Anonymous — Tue, 10 Oct 2017 09:50:31 GMT

We can use Set analysis but this is one of the way of generating dates between MIn and Max Dates.

In Data_Table Close_Date is Date of transaction .i am searching MIN Date and MAX Date to create Dates between MIN & MAX dates.

I used Variable in looping .variable use is better than write ( num(Min(DATE("Close_Date"))) )

even in looping date should be in Number format.

Regards

sahadev

Re: FromDate, ToDate in Master Calender

hic — Tue, 10 Oct 2017 10:27:34 GMT

If you want two or more date fields to be represented by one field, you should create a Canonical Date:

Canonical Date

If you want to generate all dates between the two, you should create a reference date:

Creating Reference Dates for Intervals

HIC

Re: FromDate, ToDate in Master Calender

pradosh_thakur — Tue, 10 Oct 2017 10:40:59 GMT

if Form Date and To date are not exactly fields then you can use the date field from master calender in 2 different state and use one of them as from date and another as to date in your calculation.

regards

Pradosh

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 14:38:46 GMT

Hi Jonathan,

thanks a lot for your response and feedback,

my issue, that i am looking for, i posted yesterday here: Presentation of Values from MonthDiff as Year, Month

Thanks a lot

Beck

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 14:40:00 GMT

Hi Henric,

Thanks a lot for your feedback and responce, i will try to implement it and will report, when i achieve the solution for my issue.

Thanks a lot

Beck

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 14:41:17 GMT

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

Re: FromDate, ToDate in Master Calender

pradosh_thakur — Tue, 10 Oct 2017 14:53:57 GMT

if this solved your query please close the thread

regards

Pradosh

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 15:15:56 GMT

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

Re: FromDate, ToDate in Master Calender

pradosh_thakur — Tue, 10 Oct 2017 15:33:53 GMT

where exactly are you struck ?

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Tue, 10 Oct 2017 15:36:45 GMT

in this issue

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Wed, 11 Oct 2017 11:08:20 GMT

Thanks a lot Patil for your response and feedback

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Wed, 11 Oct 2017 17:51:18 GMT

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

Re: FromDate, ToDate in Master Calender

beck_bakytbek — Thu, 12 Oct 2017 15:36:20 GMT

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