3 Replies Latest reply: Aug 3, 2017 7:49 AM by Tal Sibony RSS

    Function or technique to find most successful dimension by measure - qlik sense

    Tal Sibony

      let's take the data set below (loaded to qlik):

        

      datehouraccountsales
      8/2/20171xx$20
      8/2/20172xx$25
      8/2/20173xx$18
      8/2/20171yy$30
      8/2/20172yy$12
      8/2/20173yy$8
      8/3/20171xx$13
      8/3/20172xx$7
      8/3/20173xx$22
      8/3/20171yy$3
      8/3/20172yy$17
      8/3/20173yy$10

       

      i would like to create a chart and receive for each account the most succeeding sales hour:

       

      accounthour
             xx    3
      yy    1

       

      account xx most succeeding sales hour is 3, because $18+$22=$40, more than:

      1: $20+$13=$33

      2: $25+$7=$32

       

      have any technique or function to receive such an output?

       

      tnx!

      Tal