2 Different dates in data model

[krish2459]

Hi ,

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.

Requesting to attach QVF file for reference.

Best Regards,

Krish

[Taoufiq_Zarra]

@krish2459  Maye be this help:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

[krish2459]

Hi,

Itwas helpful.

I'm also attaching the sample data.

Logic : sum(Amount LC)/ Sum(LGORT_SALK3)

I need create Master calender with these two dates.

Thanks,

Kishore

[krish2459]

Hi,

Any suggestion on the request.

Thanks,

Krish..