Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
soniasweety
Valued Contributor 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?

Tags (4)
5 Replies
prma7799
Honored Contributor III

Re: Join two exp

Try like this

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

soniasweety
Valued Contributor III

Re: Join two exp

let me try thanks

Re: Join two exp

This

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

MVP
MVP

Re: Join two exp

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
Honored Contributor III

Re: Join two exp

As jontydkpi‌ suggested you can try like this

(NullCount(A) + Count(A))

+

(NullCount(B)+Count(B))