topic Re: Calender Issue in QlikView

Calender Issue

Thu, 26 Feb 2015 12:39:30 GMT

Hi All,

I have a data model with multiple facts and every fact table has a date reference.

eg:

Fact 1 - Order date

Fact 2 - Shipment date

Fact 3 - Recept Date

Now i am trying to build a master calender. from which of the date available i should be considering to get min and max date ?

it would be great if you can provide me with some sample.

Logical if i see i should consider Order date for creating my master calender but what if there comes a new fact which may have dates well before min of order date ?

Please help me understand.

Thanks

Re: Calender Issue

jonathandienst — Thu, 26 Feb 2015 12:44:06 GMT

This excellent article should help you.

Canonical Date

HTH

Jonathan

Re: Calender Issue

Anonymous — Thu, 26 Feb 2015 12:48:10 GMT

Hi,

Use Canonical-date by Henric

Regards

Neetha

Re: Calender Issue

Thu, 26 Feb 2015 14:41:56 GMT

Thanks Jonathan for pointing me out to the post. and yes i feel this will work in my case.

Thanks