checking null in set analysis

[Anonymous]

=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

[sunny_talwar]

Try like this

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

[prma7799]

Please check this

NULL handling in QlikView

[PrashantSangle]

What is your final requirement???

[sunny_talwar]

Or this

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

[balabhaskarqlik]

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

[Anonymous]

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

[Sergey_Shuklin]

Hello!

There are some ways to count null values:

And here the manual:

NULL handling in QlikView

[cspindley]

u help, thanq

[cspindley]

ta