10 Replies Latest reply: Apr 5, 2017 7:40 AM by Elizabeth Viso RSS

    Division calculation in Qlik Sense

    Elizabeth Viso

      Hello

       

      I have a table that shows the amount of inspections done per room and I need to calculate the percentage done based on it if passed or not.

       

      So for the "Dated"  inspections there was 3 in total and only 2 passed, so it's 2/3 = 67% which I wrote out the expression like this:

       

      Count({<Dated={'Yes'}>}Dated)/Count([Unit])

      *Count the total Dated inspections that = yes and / it by the count of units

       

      I'm getting 100% but I know it should be 67%. Any ideas?

       

      Thanks!!