Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nehasaxena
Creator II
Creator II

Multiple Dates in Data Model

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

2 Replies
Anonymous
Not applicable

This may help you.Master Calender with 4 date fields

You may create a link table.