Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Esus
Contributor
Contributor

Multiple dates

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

 

Labels (1)
3 Replies
Taoufiq_Zarra
Master II
Master II

Hi,

can you share some Sample Data

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
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