Multiple dates

[Esus]

Hey Qlik Community,

I am creating an application that has two tables each with a key that has multiple respective dates.

The first table has a key for members and the membership date. The second table has a key for a claim , a key for a patient and the claim date. The two tables join using the patient key.

I am looking to create a table that counts the number of patients in each month as well as the number of referrals in each month however the issue I am rubbing into is that I have multiple dates. 

End result should look like this:

             #Members       #Claims

Jan        2,000               500

feb        2,000                 600

[Taoufiq_Zarra]

Hi,

can you share some Sample Data

[Brett_Bleess]

Esus, the best I can do with what you have provided is the following link, this is the Design Blog area of community, it is where our internal experts post how-to items, that is about the only thing I can offer given what you provided, if you are not able to post sample data etc., I am doubtful you will get much further, but hopefully the Design Blog link may let you find some posts that will help at that point.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

I think some specific posts that may be in play would be the following:

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

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett

[rwunderlich]

Download and review this tutorial:

Qlikview Cookbook: Tutorial - Using Common Date Dimensions http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

The example shown is similar to your question.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com