Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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!