10 Replies Latest reply: May 7, 2018 9:13 AM by Michele De Nardi RSS

    Include a Condition in a #1 KPI.

    Rebecca Kutz

      @Dear Qlik Community

       

      I've chooses a KPI to show how many employess work in a company, by using the count expression. However, people either work in Sales/Marketing or Production. I would like to include that as a condition in my KPI. I tried the following:

       

      =count(if([job_function]='Production'_A,[job_function])

       

      However it doesn't work. Does anyone has a hint for me?

       

      Thanks and kind regards,

      Rebecca