topic Re: Linked dates - date is the only common dimension in QlikView

Linked dates - date is the only common dimension

josephinetedesc — Fri, 19 Jun 2015 07:39:11 GMT

Hi I am developing a schedule vs planned application.

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

Re: Linked dates - date is the only common dimension

gautik92 — Fri, 19 Jun 2015 07:47:47 GMT

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)

Re: Linked dates - date is the only common dimension

josephinetedesc — Fri, 19 Jun 2015 10:01:42 GMT

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.

Re: Linked dates - date is the only common dimension

josephinetedesc — Sat, 20 Jun 2015 11:38:31 GMT

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!