Re: Set analysis for time - Qlik Community

prma7799 · ‎2015-05-07

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

PM

Anonymous · ‎2015-05-07

SLA =2:55:00 AM

is it 2 hr 55 min ? or time ?

Thanks

BKC

prma7799 · ‎2015-05-07

It is Time.

Anonymous · ‎2015-05-07

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

prma7799 · ‎2015-05-07

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 .

sunny_talwar · ‎2015-05-07

Try this may be:

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

jagan · ‎2015-05-07

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.

prma7799 · ‎2015-05-07

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

sunny_talwar · ‎2015-05-07

Try this:

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

jagan · ‎2015-05-07

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.