topic Start date and Completion date - do I need 2 calendars? in QlikView

Start date and Completion date - do I need 2 calendars?

josephinetedesc — Fri, 30 Sep 2016 04:40:37 GMT

Hi all

in my application I need a [start date] which is rounded up into months weeks etc and a [completion date] which is rounded up into months week etc.

I am thinking something along the lines of:

load

month(startDate) as StartMonth,

year(startDate) as StartYear,

month(endDate) as EndMonth,

year(endDate) as EndYear

whilst this is nice and simple - the problem will come when someone will want financial years quarter etc.

when that happens will I need to have 2 calendars - one for Start Dates and one for Completion Dates? I have seen Michael Tarallo's script for the use of Calendar scripts - but I am not sure how to apply it for this situation.

Thank you

Jo Tedesco

Re: Start date and Completion date - do I need 2 calendars?

zhadrakas — Fri, 30 Sep 2016 05:32:45 GMT

yes you can do this. check this:

Handling Multiple Calendars.qvw

Canonical Date

or you can use Common Date Dimension and Shared Calenders:

Tutorial - Using Common Date Dimensions and Shared Calendars

Re: Start date and Completion date - do I need 2 calendars?

josephinetedesc — Fri, 30 Sep 2016 05:55:50 GMT

I think it will be easier if it stick to 2 calendars ... might be easier for users too!

Si I suppose I used Michael's script twice and be careful not to duplicate variable names

Thank you Tim.

Re: Start date and Completion date - do I need 2 calendars?

zhadrakas — Fri, 30 Sep 2016 06:02:08 GMT

For just two Dates its easier to use two seperate calenders. Just give them a different prefix or Suffix in field names.

Dont Forget to mark this question as answered.

regards

tim

Re: Start date and Completion date - do I need 2 calendars?

nagarjuna_kotha — Fri, 30 Sep 2016 06:15:38 GMT

if you don't want two calender's ,Create one unlined calendar , By using that you can control those in front end

I hope this may helps you

-Nagarjun

Re: Start date and Completion date - do I need 2 calendars?

josephinetedesc — Fri, 30 Sep 2016 13:25:46 GMT

thank you