topic Re: Data Modeling Multiple date issue in QlikView

Data Modeling Multiple date issue

Wed, 25 Nov 2020 16:16:04 GMT

How to deal with multiple dates in data model.

Each table have one date I need a universal date it should work with all tables

please find attached excel and Qvw please suggest

Re: Data Modeling Multiple date issue

m_woolf — Fri, 26 May 2017 19:17:28 GMT

Tutorial - Using Common Date Dimensions and Shared Calendars

Re: Data Modeling Multiple date issue

Oleg_Troyansky — Fri, 26 May 2017 19:22:41 GMT

There are many ways of dealing with this problem. My favorite solution is to build a concatenated fact table with all your facts as concatenated slices, and rename all your dates into one field name Date. This way, you can use one Master Calendar for all dates and differentiate you dates using the new field that we usually call "Fact Type".

You can learn these Data Modeling techniques at the Masters Summit for Qlik - coming to Boston this October. If you can't attend the Masters Summit, check out my book QlikView Your Business. I also describe these techniques there.

cheers,

Oleg Troyansky

Re: Data Modeling Multiple date issue

Fri, 26 May 2017 20:21:35 GMT

i cant understand where to use that call calander

please help it's aurgent

Re: Data Modeling Multiple date issue

Anil_Babu_Samineni — Sat, 27 May 2017 01:59:35 GMT

I agree with Oleg.

Check here the solution in attachment. I've attached qvw and qvs.

Re: Data Modeling Multiple date issue

Sat, 27 May 2017 03:16:16 GMT

Awesome Anil Thanks.