Aggregating the data by different dimensions but putting them in single chart/ table

[gopalopsharma]

Hello team,

I am a part of company, where we get customer's applications to process. Now there are two dates here:

1. Date on which application was created (inflow)

2. Date on which application was processed (outflow)

I want to show a comparative analysis of both in a single trend chart, which will show two series- 1st for inflow, 2nd for outflow. So idea is to create a single generic Week/ month column & then show the two series according to their respective dates.

Is it possible somehow?

My Data looks something like below:

application_id	created_date	processed_date
1	16-Mar-2019	20-Mar-2019
2	19-Mar-2019	23-Mar-2019
3	22-Mar-2019	26-Mar-2019
4	25-Mar-2019	29-Mar-2019
5	28-Mar-2019	1-Apr-2019

[Gysbert_Wassenaar]

Perhaps you're looking for this: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944

[gopalopsharma]

Thanks  @Gysbert_Wassenaar !

But this method will lead to huge data bloat up, creating several entries for each record. Also, my question is more around creating one reference date column for 2 different columns in one shot & eventually rolling them both up as per reference column. 

[Gysbert_Wassenaar]

Perhaps a table like this suffices for your purposes:

application_id, date, type_of_date
1, 03/16/19, created_date
2, 03/19/19, created_date
3, 03/22/19, created_date
4, 03/25/19, created_date
5, 03/28/19, created_date
1, 03/20/19, processed_date
2, 03/23/19, processed_date
3, 03/26/19, processed_date
4, 03/29/19, processed_date
5, 04/01/19, processed_date

[gopalopsharma]

Yeah, tried it already, need to give it a different angle again.

Thanks for the idea @Gysbert_Wassenaar