Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dynamic_girl
Contributor

checking null in set analysis

=count({$<x={"isnull(y)"}>}x)

this expression gvng me 0 value

need to check null value for x field

x,y are fiel;d names

9 Replies

Re: checking null in set analysis

Try like this

=Count({$<x={"=isnull(y)"}>}x)

prma7799
Honored Contributor III

Re: checking null in set analysis

Please check this

NULL handling in QlikView

Re: checking null in set analysis

What is your final requirement???

Great dreamer's dreams never fulfilled, they are always transcended.

Re: checking null in set analysis

Or this

=Count({$<x={"=Len(Trim(y)) = 0"}>}x)

balabhaskarqlik
Honored Contributor

Re: checking null in set analysis

=Count({$<x={"=Len(Trim(y)) = 0"}>}DISTINCT x)

robin_hausdoerfer
Valued Contributor III

Re: checking null in set analysis

=count({$-<y={"*"} > } x)

Sergey_Shuklin
Valued Contributor

Re: checking null in set analysis

Hello!

There are some ways to count null values:

count_null.png

And here the manual:

NULL handling in QlikView

Highlighted
cspindley
New Contributor III

Re: checking null in set analysis

u help, thanq

cspindley
New Contributor III

Re: checking null in set analysis

ta