Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try: count({<Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>+<Jour={'Sat'},Time={'>=04:00:00<=08:00:00'}>}CallDuration)
I get 0 as answer and the expected response is 50.
Please post a qlikview document that demonstrates the problem.
Actually the for monday to friday it is working fine.Just sat its showing as 0
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'}
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''}
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
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
Hi it works fine.
Actually in french, 'Sat' is translated as 'sam.'
I didn't notice the point.
Thanks for your help.