1 Reply Latest reply: Jul 2, 2015 2:10 AM by Henric Cronström RSS

    average per interval, per day name

    Helena Silver

      Hallo

       

      please could some one help me. I have posted this a couple of days before but no luck.

      I am so stuck and very new to qlikview.

       

      I have a table showing volumes per interval (hour) for June month per weekday (i.e Mon, tues, wed etc).  I know what to know on average for the month of June how many volumes I received on a Mon, Tue, Wed etc.   In example below June month got 4 Fridays therefore on Fridays we receive on average 29 calls between 8 and 9 and on average 44 calls between 9 and 10.

       

      how do I write it in my expression field.

       

      thank you very much 

       

      JuneFriday
      Hour_IntvolumeAve per day
      8114          28.50
      9175          43.75
      10139          34.75
      11128          32.00
      12129          32.25
      13116          29.00
      14134          33.50
      15126          31.50
      1635             8.75
      1718             4.50
      187             1.75
      Total1 121        280.25