Linked dates - date is the only common dimension

[josephinetedesc]

Hi I am developing a schedule vs planned application.

So

I have a date and machine producing widgets and taking a certain amount of time(called DurationTime)

Then I have a schedule which contains the date and the machine and the amount of time it can work.

I have read the document 5834 from:

https://community.qlik.com/docs/DOC-5834

but I am trying to think - do I have a common field?

so what I am trying to do is:

file 1.

SchedDate

machine

duration of an operation

file 2.

PlannedDate

machine

total time available for operations to take place.

What I initially did was have file 1

and made:     date as DateFull,

file 2

made     PlannedDate as DateFull

Then I had a copy of a Master Calendar that did all the Dates as Financial dates etc.

I am having problems:

Not when i use DateFull operations such as MonthName, and WeekNum - however when I try to select on month using just Month (I am not sure how to go about it) Is this a Master Calendar problem?

When I get home I will try some more diagnostics.

Thank you

Jo

[gautik92]

create two different calendars and use those calendars in exprsn lik this

=num(Sum({$< DisCALYear = {$(=Max(DisCALYear))},

BuilCALMonthID={$(=max({$< DisCALMonthID = {$(=Max(DisCALMonthID))} ,DisCALYear = {$(=Max(DisCALYear))} >}BuilCALMonthID) } > } TotalVolume),0.00)

[josephinetedesc]

Thank you for your response ...

I hve now read another publiation - QlikView date fields.

I think the problem might be related to one date being a date stamp with dates and times.  The Master Calendar is in Excel and is a date in the format DD/MM/YYYY.  This might be the reason that was was working has stopped working.  

I did think that perhaps I could have used =MonthName(DateFull) as the dimension in my graph - but you cannot do that ...in a list box.  You can only use a dimension that has been loaded at the script time.

Jo

[josephinetedesc]

Ah ... I have discovered another problem.  Set 1 dates (they begin on 1 April) Set 2 dates begin on January 1 and go to at June 2016.  I have a choice  I suppose to limit the second calendar ...  here is hoping!