How to use Isnull() function in Set analysis

[vipingarg23]

Hi Team,

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

[prma7799]

Like this??

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

[zhadrakas]

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

[prma7799]

also check this link

How to handle NULL values​​, ANDs and ORs in SET ANALYSIS: | QlikView Help, Tips & Hints

[manoranjan_d]

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

[VishalWaghole]

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

[vipingarg23]

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)

[teempi]

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]

Hi,

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

-Teemu