Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Search instead for
Did you mean:
Creator

## How to use Isnull() function in Set analysis

Hi Team,

How can we implement Isnull() function in Set analysis?

21 Replies
Creator
Author

Hi Anil,

Please find the sample file.

Here I want count of B where A is null.

Master II

Count({<B={"=(len(trim(B))=0)"}>}A)

OR

Count(DISTINCT {<B={"=(len(trim(B))=0)"}>}A)

Learning never stops.

Looks like, This is working?

Count(If(Len(A)=0,B))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator
Author

Great Anil, It is working fine..Thanks for your quick reply.

Master II

This didn't work ?

Learning never stops.
Creator
Author

Anil, How can we use it in set analysis?

Count({<A = {"=Len(A)=0"}>} B)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator
Author

Great Anil. Thanks..

Contributor II

I don't think this is working, as how can we compare value of A with a condition equaling length of that field =0. if we have below example values of table:

A         B
1         100
NULL 200
Then how can we do this set analysis when A= {"=Len(A)=0"}>}.

Partner - Creator

Count ( { \$ - < B ={"*"} > } A)
Is the correct solution.
Take everything and subtract the non-null() values, and your result is only the isnull() values.

Credits to teempi !

Community Browser