Discussion board where members can get started with QlikView.
I have one bar chart with GEO dimension
and two expression
second expression I want to include nullcount to expression its not working below I tried
nullcount((count(A)+Count(B)) its giving error.
how can I write this?
Try like this
=count(IsNull(A) +count(IsNull(B)) )
let me try thanks
=Count(if(IsNull(A)=-1,A)) + Count(If(IsNull(B)=-1 B))
Is this what you mean:
1. Count(A) + Count(B)
2. NullCount(A) + NullCount(B)
As jontydkpi suggested you can try like this
(NullCount(A) + Count(A))