9 Replies Latest reply: Jun 3, 2016 1:22 AM by Avinash R RSS

    Analysis by hour

    Vítor Castro

      Hello everyone,

       

      i am starting with Qlikview so i don't have yet a lot of experience with this tool and right now i have a problem:

       

      I have this data set:

       

      I am trying to do an analysis by hour. I want the ID_Person with the max records by hour by day in a group.

       

      I tried to create a straight table with dimensions Id , Date, Hour, Group,

      and an expression "=num(sum({$<ID={'Active'}>}#Count),'#.##0')" to obtain the "Sum" of records of each ID but the result was this table:

       

      1,

      IDDateHourGroupSum
      12016-01-0110134
      22016-01-01101345
      42016-01-01101456
      32016-01-0111136
      52016-01-01102100
      62016-01-01102145
      72016-01-02142130

       

      What i was expecting was this:

       

      IDDateHourGroupSum
      42016-01-01101456
      32016-01-0111136
      62016-01-01102145
      72016-01-02142130

       

       

      I'm not getting only the max row by hour by day.

       

      Can someone help me?

       

      Thanks a lot