Solved: Re: Nested Count If statement in expression help - Qlik Community

Anonymous · ‎2018-02-12

Annual
Backup
Complete
Owner

I have a pivot table with columns similar to the above. I would like to do another chart that only counts cells that do not show as "Complete". I tried the below formula but its not working, does anyone have any suggestions?

If(([Annual] <> 'Complete'),Count[Annual], Null())

Anil_Babu_Samineni · ‎2018-02-12

Perhaps this?

Count({<Annual -= {"Complete"}>} Annual)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2018-02-12

Perhaps this?

Count({<Annual -= {"Complete"}>} Annual)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2018-02-12

doesnt the field have to be in brackets "[]" it doesnt pick it up otherwise for me