Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

Try like this

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

prma7799
Master III
Master III

Please check this

NULL handling in QlikView

PrashantSangle

What is your final requirement???

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
sunny_talwar

Or this

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

balabhaskarqlik

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

Anonymous
Not applicable
Author

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

Sergey_Shuklin
Specialist
Specialist

Hello!

There are some ways to count null values:

count_null.png

And here the manual:

NULL handling in QlikView

cspindley
Contributor III
Contributor III

u help, thanq

cspindley
Contributor III
Contributor III

ta