Discussion Board for collaboration on QlikView Layout & Visualizations.
Had post teh query in another discussion group 5 days before and haven't received any reply.
Hence re posting in this group.
I am trying to create a bar chart with Interval as dimension and % of cases closed as line chart.
Below is sample data.
Created time Closed time Transaction Number
1:00 PM 1:15 PM Raj1
1:45 PM 2:30 PM Raj2
2:30 PM 2:45 PM Raj3
4:00 PM 4:30 PM Raj4
4:45 PM 5:30 PM Raj5
6:00 PM 6:15 PM Raj6
6:45 PM 7:00 PM Raj7
8:00 PM 9:00 PM Raj8
8:45 PM 9:05 PM Raj9
10:30 PM 11:00 PM Raj10
11:00 PM 11:35 PM Raj11
11:30 PM 11:45 PM Raj12
% % of closure is number of transaction closed at an interval basis of closed time / Number of transactions created in same interval.
In teh above example for an Interval 1 Pm to 2 PM the % of closure is 50% ( 1 Closed / 2 Recieved)
Go to Solution.
I'm studying your interesting problem.
Can you see the attachment?
(I added this row to check the correct behaviour of the expression: 6:00, 8:15, Raj13)
I'll wait for your feedback.