Null value in set analysis

[Anonymous]

I would like to know the sales values when Top BU is null. I tried the below expression but it is not working.

sum({<[Top BU]={"$(=IsNull([Top BU]))"}>}Sales).

I would like to have your suggestions to correct my expression.

[rwunderlich · Accepted solution]

I think Anil's answer is correct. Note the "-" after $.  See also

NULL handling in QlikView

-Rob

[Anonymous]

Try this

sum({<[Top BU] ={'=$(=len([Top BU])=0)'}>}Sales)

[Anonymous]

I think suggestions from AMnish Kachhia, rgv rand , Anil Babu should be worked.

But they did not work for me, not sure maybe because of the model I have.

Good article to know about the 'NULL'.

NULL handling in QlikView

However, I solved my problem by adding the below calculated dimension without changing anything in the expression.

if(IsNull([Top BU]),'Yes'), and checked the option "Suppress when value is NULL"