7 Replies Latest reply: Nov 21, 2017 6:14 AM by Devarasu R RSS

    How to calculate average between columns in Qlik Sense

    Shahzad Ahsan

      Hi Everyone

      I have table in excel like this

       

      DepartmentABCDE
      D1269633
      D2698228
      D34785963
      D42548586
      D535889

       

      I want the result like this

       

      DepartmentAverageRank
      D116.62
      D210.62
      D3301
      D418.42
      D56.63

       

      Please answer how to calculate Average & Rank. See the below hint.

      Average= A+B+C+D+E/5

      Rank= If Average > 20 then Rank=1, If Average Between 10 and 20 then Rank=2, If Average < 10 then Rank=1