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

    Division calculation in Qlik Sense

    Elizabeth Viso



      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 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?