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: 
vipingarg23
Creator
Creator

How to use Isnull() function in Set analysis

Hi Team,

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

View solution in original post

21 Replies
prma7799
Master III
Master III

Like this??

sum({($ -<Code={'*'}>) >} Amount)

zhadrakas
Specialist II
Specialist II

what do you want to do ?

i think you can somethink like

count({$<qty={"*"}>}checknum)

-> this will Count everything that is not null

count({$<qty-={"*"}>}checknum)

-> this will Count everything that is null

manoranjan_d
Specialist
Specialist

Sum({<field1-={"*"}>} field2)

VishalWaghole
Specialist II
Specialist II

=sum({<DimensionField-={*}>} FactField)

vipingarg23
Creator
Creator
Author

Sorry guys. But Nothing is working out. I am explaining more with example:

I want count of A where B is null. So I am using below formula:

Count({<B-={"*"}>}A)

But it is not working.

Anil_Babu_Samineni

If A and B are associate each then, Try this? Or post sample to test

Count({<B = {"=Null()"}>} A)

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
teempi
Partner - Creator II
Partner - Creator II

Hi,

I don't think that count({$<qty-={"*"}>}checknum) gives the correct results since nulls cannot be selected. Something like this will have to be used and seemed to work in a simple example application:


count( {$-<qty={"*"}>} checknum)


-Teemu

teempi
Partner - Creator II
Partner - Creator II

Hi,

Try this: Count({$-<B={"*"}>}A)


-Teemu