Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gopalopsharma
Creator
Creator

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

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_idcreated_dateprocessed_date
116-Mar-201920-Mar-2019
219-Mar-201923-Mar-2019
322-Mar-201926-Mar-2019
425-Mar-201929-Mar-2019
528-Mar-20191-Apr-2019

 

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
gopalopsharma
Creator
Creator
Author

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



talk is cheap, supply exceeds demand
gopalopsharma
Creator
Creator
Author

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

Thanks for the idea @Gysbert_Wassenaar