Count when 2 columns are empty on QlikSense

Question

I need some help to count the number of line empty in 2 columns on QlikSense formula.

In the example, when the column "Item" is filled, I would like to count the number of lines which have both "Info 1" and "Info 2" empty.

In this case it should be 2 (Line B and Line E).

Does anybody know how to do this formula?

Many thanks,

Wil

Answer 1

I found this post with the solution.