Include a Condition in a #1 KPI.

[Anonymous]

@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

[Anonymous]

I would like to do so but some how cant see the "correct" reply button.

[micheledenardi]