topic Second connection in QlikView

Second connection

Anonymous — Mon, 12 Mar 2012 09:04:41 GMT

Hi all,

I'm making a dashboard on a telephone database. One of the KPI's is the time between throughconnect and answering.

I give an example:

Event description:

INIT = Inbound Call

CON = Connection (Asnwering)

INT = Throughconnect

DIS = Disconnected (Hangup)

Call ID	RecNo	EventCode	EventTime
123	1	INIT	12:01:53
123	2	CON	12:02:06
123	3	INT	12:02:15
123	4	CON	12:02:23
123	5	INT	12:02:30
123	6	CON	12:02:45
123	7	DIS	12:03:01

Now I need a set with the time of the second CON-event per CallId that is after the first INT. I hope someone knows how to do......

Best regards,

Arjan

Message was edited by: arjanijlenhave

CELAMBARASAN — Mon, 12 Mar 2012 09:12:29 GMT

Hi,

Have CallID as dimension.

Interval(Max({EventCode={'CON'}} EventTime)-Only({<EventCode={'INT'}>} EventTime),'hh:mm:ss') as expression

Hope it helps

Celambarasan

Anonymous — Mon, 12 Mar 2012 09:23:03 GMT

Hi Celambarason,

Thanks for helping!

I've edited my discussion....How to do now?

Arjan

CELAMBARASAN — Mon, 12 Mar 2012 09:37:35 GMT

Hi,

For this you have to arrive value in the load script.

Load the data by using order by callID , EventCode,EventTime in ascending order.

Then

Load

Autonumber(EventCode&EventTime,CallID&EventCode) as Number

Resident tableName;

Then you can easily picked up based on the number.

Interval(Only({EventCode={'CON'},Number={2}} EventTime)-Only({<EventCode={'INT'},Number={1}>} EventTime),'hh:mm:ss')

Hope it helps

Celambarasan

Anonymous — Mon, 12 Mar 2012 12:37:02 GMT

Thanks for your help!!!

Arjan