topic Re: Join two exp in QlikView

Join two exp

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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?

prma7799 — Fri, 27 Oct 2017 05:41:33 GMT

Try like this

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

soniasweety — Fri, 27 Oct 2017 05:53:01 GMT

let me try thanks

its_anandrjs — Fri, 27 Oct 2017 06:08:08 GMT

This

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

jonathandienst — Fri, 27 Oct 2017 06:32:04 GMT

Is this what you mean:

1. Count(A) + Count(B)

2. NullCount(A) + NullCount(B)

prma7799 — Fri, 27 Oct 2017 06:36:52 GMT

As jontydkpi‌ suggested you can try like this

(NullCount(A) + Count(A))

(NullCount(B)+Count(B))