Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
can you share some Sample Data
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
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