topic Multiple dates in QlikView

Multiple dates

Esus — Sat, 16 Nov 2024 01:44:03 GMT

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

Re: Multiple dates

Taoufiq_Zarra — Tue, 10 Dec 2019 16:47:50 GMT

Hi,

can you share some Sample Data

Re: Multiple dates

Brett_Bleess — Wed, 18 Dec 2019 13:44:22 GMT

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

Re: Multiple dates

rwunderlich — Wed, 18 Dec 2019 14:47:48 GMT

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