Question on how to count by date

[shirleyc40]

Hello!

I have data that looks like this

Accepted Date	Policy Status	Initial Submission Date
1/2	Accepted	1/1
1/2	Declined	1/2
1/3	Accepted	1/3

I want to be able to create a bar chart where the dimension is a general master date that I have created, and then the measures would reflect this:

Where for the date 1/1 I would have a count of 1 because there is one entry that has the initial submission date of 1/1 and then on 1/2 I have an accepted count of 1 because that same entry was accepted on 1/2

[rwunderlich]

Download the Qlik Sense example here:

http://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

This is a tutorial of how to handle multiple fact dates.

-Rob