9 Replies Latest reply: Jun 30, 2015 6:56 AM by Hasvine Dhurmea RSS

    working time

    Hasvine Dhurmea

      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