Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Bar Chart with Closure %

HI,

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)

1 Solution

Accepted Solutions
MVP
MVP

Re: Bar Chart with Closure %

PFA

2 Replies
elena888
Valued Contributor

Re: Bar Chart with Closure %

Hi,

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.

Elena

MVP
MVP

Re: Bar Chart with Closure %

PFA

Community Browser