topic Re: Set analysis for time in QlikView

Set analysis for time

prma7799 — Thu, 07 May 2015 09:27:39 GMT

Hi All,

I have two fields status = ACD and SLA =2:55:00 AM like this.

I want total number of call logs where status is ACD and SLA is less than 30.

for that i wrote expression like Count({<sStatus={'ACD'} , SLA ={}[Call Log ID]).

So how to fine SLA is less than 30.

Thanks

Re: Set analysis for time

Anonymous — Thu, 07 May 2015 09:34:35 GMT

SLA =2:55:00 AM

is it 2 hr 55 min ? or time ?

Thanks

BKC

Re: Set analysis for time

prma7799 — Thu, 07 May 2015 09:38:50 GMT

It is Time.

Re: Set analysis for time

Anonymous — Thu, 07 May 2015 09:53:07 GMT

so you can minus it with current time to get actual spent time in hours

Re: Set analysis for time

prma7799 — Thu, 07 May 2015 09:58:29 GMT

I have SLA data like below

SLA

0:21

0:22

1:12

0:29

0:30

0:28

0:25

0:28

0:20

0:22

0:29

0:32

0:27

0:29

0:21

0:31

0:33

0:22

0:43

0:29

0:31

0:33

0:21

0:27

0:25

0:22

0:31

0:27

0:28

0:23

0:25

0:27

0:23

0:30

0:25

0:29

0:26

0:23

0:30

0:35

0:21

0:28

0:24

0:25

0:21

0:26

0:24

0:32

0:35

0:24

0:25

0:34

0:24

0:26

0:28

0:24

0:26

0:22

0:17

0:27

0:30

0:33

0:31

0:22

0:25

0:27

0:22

1:24

0:35

0:33

0:23

0:28

0:29

0:24

0:22

0:26

0:23

0:31

0:30

0:27

0:06

0:24

0:25

0:20

0:30

0:25

0:21

0:22

0:24

0:25

0:22

0:29

0:32

0:21

0:20

0:24

0:27

0:28

0:25

0:23

0:32

0:33

0:25

0:24

0:21

0:24

0:15

0:26

0:29

0:24

0:23

0:25

0:21

0:24

0:27

0:14

0:26

0:22

0:27

0:28

0:24

0:23

0:22

0:17

0:28

0:29

0:32

0:26

0:22

0:27

0:24

0:21

0:30

0:24

0:27

0:22

0:27

0:28

0:26

0:31

0:34

0:23

0:25

0:31

0:21

0:25

0:26

0:29

0:25

0:26

0:34

0:23

0:28

0:23

0:27

0:26

0:27

0:23

0:24

0:26

0:21

0:25

0:18

0:27

0:24

0:27

0:24

0:27

0:28

0:21

0:26

0:29

0:27

0:26

0:23

0:25

0:26

0:23

0:31

0:26

0:24

0:27

0:31

0:29

0:34

0:20

0:22

0:26

0:24

0:30

0:11

0:22

0:23

0:26

0:19

0:22

0:21

0:24

0:23

0:20

0:24

0:21

0:25

0:21

0:22

0:28

0:21

0:23

0:22

0:26

5:15

0:21

2:55

0:35

0:22

0:26

0:29

0:31

0:24

0:25

0:24

0:21

0:23

0:22

0:31

0:28

0:22

0:23

0:12

0:10

0:22

0:26

0:27

0:28

and I want SLA is less than 30 .

Re: Set analysis for time

sunny_talwar — Thu, 07 May 2015 10:04:06 GMT

Try this may be:

=Count({<Status = {'ACD'} , SLA = {"<$(=Interval(Interval#(30, 'mm'), 'h:mm'))"}>}[Call Log ID])

Re: Set analysis for time

jagan — Thu, 07 May 2015 10:06:18 GMT

Hi,

Try like this

LOAD

SubField(SLA, ':', 1) * 60 + SubField(SLA, ':', 2) AS SLAInMinutes

FROM DataSource;

Now in chart try like this

Count({<SLAInMinutes={'<30'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: Set analysis for time

prma7799 — Thu, 07 May 2015 10:14:15 GMT

Hi Sunindia,

Is this come in second because i want Call answered in 30 sec for that i need to use SLA is less than 30

Re: Set analysis for time

sunny_talwar — Thu, 07 May 2015 10:35:21 GMT

Try this:

=Count({<Status = {'ACD'} , SLA = {"<$(=Interval(Interval#(30, 'ss'), 'm:ss'))"}>}[Call Log ID])

Re: Set analysis for time

jagan — Thu, 07 May 2015 10:38:46 GMT

Hi,

Did you tried this

LOAD

SubField(SLA, ':', 1) * 60 + SubField(SLA, ':', 2) AS SLAInSeconds

FROM DataSource;

Now in chart try like this

Count({<SLAInSeconds={'<30'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: Set analysis for time

prma7799 — Thu, 07 May 2015 10:41:37 GMT

Yes I tried but values is getting 0.

Re: Set analysis for time

sunny_talwar — Thu, 07 May 2015 10:43:55 GMT

Did this work? If not what is the current format of your field SLA? is it m:ss

Re: Set analysis for time

jagan — Thu, 07 May 2015 10:44:15 GMT

Hi,

It is working for me, can you attach a sample file?

Regards,

Jagan.

Re: Set analysis for time

prma7799 — Thu, 07 May 2015 11:21:22 GMT

Hi Jagan,

PFA for the same.

Thanks