How to sum up in KPI

[Newbie_To_Qlik]

I need to create a KPI to sum up the first visit fix. Anyone can help

Asset ID	First Visit Fix
CL10013	No
CL10013	No
CL10013	Yes
CL10013	No
CL10013	Yes

[rubenmarin · Accepted solution]

Hi, I'm not sure of what you want, you give almost no info. You can try with:

Sum({<[First Visit Fix]={'Yes'}>} [FieldToSum]) 

or: Count({<[First Visit Fix]={'Yes'}>} [First Visit Fix])