Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Join two exp

Hi all,

I have  one bar chart with  GEO dimension

and two expression 

1. count(A)+Count(B)

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?

5 Replies
prma7799
Master III
Master III

Try like this

=count(IsNull(A) +count(IsNull(B)) )

soniasweety
Master
Master
Author

let me try thanks

its_anandrjs
Champion III
Champion III

This

=Count(if(IsNull(A)=-1,A))  + Count(If(IsNull(B)=-1 B))

jonathandienst
Partner - Champion III
Partner - Champion III

Is this what you mean:

1. Count(A) + Count(B)

2. NullCount(A) + NullCount(B)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
prma7799
Master III
Master III

As jontydkpi‌ suggested you can try like this

(NullCount(A) + Count(A))

+

(NullCount(B)+Count(B))