Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

working time

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

9 Replies

Re: working time

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


talk is cheap, supply exceeds demand
Not applicable

Re: working time

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

Re: working time

Please post a qlikview document that demonstrates the problem.


talk is cheap, supply exceeds demand
Not applicable

Re: working time

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

Re: working time

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'}


talk is cheap, supply exceeds demand
Not applicable

Re: working time

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''}

Not applicable

Re: working time

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

satyapaleti
Contributor II

Re: working time

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

Not applicable

Re: working time

Hi it works fine.

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

I didn't notice the point.

Thanks for your help.

Community Browser