Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Perhaps you're looking for this: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944
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.
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
Yeah, tried it already, need to give it a different angle again.
Thanks for the idea @Gysbert_Wassenaar