topic Re: working time in QlikView

working time

Tue, 30 Jun 2015 08:44:22 GMT

Hello Guys,

I have an issue.

I need to calculate the calls received during working hours.

We work from Mon to Sat.

Mon to Fri : 04:00:00 to 15:00:00

Sat: 04:00:00 to 08:00:00

My expression current expression is:

count({<Time={'>=04:00:00<=15:00:00'}>}CallDuration)

However, this is for only Mon to Friday.

I have used 'weekday(CallUniversalTime) AS Jour' in my load script to get the day names.

Could anyone help to write an expression so that from mon to fri, qlikview performs the calculation of calls received from 04:00:00 to 15:00:00 and on sat it takes into account only calls from 04:00:00 to 08:00:00.

Thanks,

Hasvine

Re: working time

Gysbert_Wassenaar — Tue, 30 Jun 2015 08:49:32 GMT

Try: count({<Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>+<Jour={'Sat'},Time={'>=04:00:00<=08:00:00'}>}CallDuration)

Re: working time

Tue, 30 Jun 2015 08:56:10 GMT

I get 0 as answer and the expected response is 50.

Re: working time

Gysbert_Wassenaar — Tue, 30 Jun 2015 09:02:28 GMT

Please post a qlikview document that demonstrates the problem.

Re: working time

Tue, 30 Jun 2015 09:02:40 GMT

Actually the for monday to friday it is working fine.Just sat its showing as 0

Re: working time

Gysbert_Wassenaar — Tue, 30 Jun 2015 09:06:27 GMT

If you use Jour for Day then you probably have french day names too. Use the correct case sensitive name. Or try Jour={'>=5<=5'}

Re: working time

Tue, 30 Jun 2015 09:17:29 GMT

Hi,

I Hope it will help u to complete u r take

count({$<{DAy}={"mon","Tus","Wen","Thu","Fri"},Time={'>=04:00:00<=15:00:00''} + count({$<{DAy}={"sat"},Time={'>=04:00:00<=08:00:00''}

Re: working time

Tue, 30 Jun 2015 09:23:59 GMT

Hi,

I Hope it will help u to complete u r take

count({$<{DAy}={"mon","Tus","Wen","Thu","Fri"},Time={'>=04:00:00<=15:00:00''}CallDuration) + count({$<{DAy}={"sat"},Time={'>=04:00:00<=08:00:00''}CallDuration)

Thank you

Balaji.k

Re: working time

SatyaPaleti — Tue, 30 Jun 2015 09:57:11 GMT

Hi,

count({$<{DAy}={'*'},Time={'>=04:00:00<=15:00:00''} + count({$<{DAy}={"sat"},Time={'>=04:00:00<=08:00:00''}

Try this

Thank you,

SatyaPaleti

Re: working time

Tue, 30 Jun 2015 10:56:47 GMT

Hi it works fine.

Actually in french, 'Sat' is translated as 'sam.'

I didn't notice the point.

Thanks for your help.