6 Replies Latest reply: May 11, 2016 4:04 PM by Sunny Talwar RSS

    Calculate ratio with measurements on multiple rows

    valentin lafranca

      Hi everyone,

      I'm very new on QlikSense but already loving it !

      I think I have missed something in the way of building expressions, or maybe what I want to do is not possible, but I can't find a way to do calculate my percentage. Here is an example :

       

      TaskStatusCount
      task1ok123
      task1failed5
      task2ok45
      task2failed20
      task3ok68
      task3failed2
      task4ok147
      task4failed33

       

      As you can see, each task can have 2 statuses which can be "failed" or "ok".

      I want to get the success rate of each task by calculating the ratio of successful vs failed tasks.

       

      Thanks in advance for any help !