3 Replies Latest reply: Mar 1, 2017 10:27 PM by Roll IWSP RSS

    Count with two conditions

    Roll IWSP

      Hello Sense Community,

       

      I am rather new to QilkSense and required your help for the following question.

       

      E.g. given the following priority data.

       

       

      PriorityP1P2P3P4P5
      1>150%>150%>110%>150%>90%
      2..........
      3..........

       

      AND

        

      OverDuePercentWorkType
      98%P1
      161%P2
      111%P2
      100%P2
      125%P5
      101%P1

      I planned to use the priority as Measures (1, 2 and 3).

       

      I have looked for the count statement with condition and came out with the following.

       

      count({<OverDuePercent={'>150'}, WORKTYPE={'P1','P2','P4'}>} WorkNum)

       

      However, I cant seems to add another condition of >110 P3 or >90 P5 into the count.

       

      What i want to achieve is something like this in excel using countifs with multiple conditions:

       

      countifs(OverduePercent=">150", WorkType="P1","P2","P4", OverduePercent=">110", WorkType="P3")

       

      Please help me community, sorry if my question isn't clear, i will re-explain if needed.

       

      Thanks!