topic Re: Multiple Dates in Data Model in QlikView

Multiple Dates in Data Model

nehasaxena — Tue, 18 Apr 2017 08:31:34 GMT

Hi All,

I have 2 dates in my data model. One is customer start date and another is transaction date. There are 2 KPIs where I need these dates for calculation. New customers - Based on Customer Start Date and No of Policies - Based on transaction date.

Now the problem is the top filter section of Year, Month and Quarter. If i will derive the filters from customer date it will give wrong result for No of Policies. How do I join these two dates and create calendar that I can use in filter section.

let me know if you need more info.

Any suggestions would be appreciated.

Best Regards,

Neha

Re: Multiple Dates in Data Model

Anonymous — Tue, 18 Apr 2017 08:35:00 GMT

This may help you.Master Calender with 4 date fields

You may create a link table.

Re: Multiple Dates in Data Model

swuehl — Tue, 18 Apr 2017 08:36:45 GMT

Have a look at

Why You sometimes should Load a Master Table several times

Tutorial - Using Common Date Dimensions and Shared Calendars