Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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))