Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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
Highlighted
Master III
Master III

Try like this

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

Highlighted
Specialist III
Specialist III

let me try thanks

Highlighted

This

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

Highlighted

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
Highlighted
Master III
Master III

As jontydkpi‌ suggested you can try like this

(NullCount(A) + Count(A))

+

(NullCount(B)+Count(B))