working time

[#1]

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

[Gysbert_Wassenaar]

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

[#3]

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

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[#5]

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

[Gysbert_Wassenaar]

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

[#7]

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

[#8]

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]

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

[#10]

Hi it works fine.

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

I didn't notice the point.

Thanks for your help.