Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Null value in set analysis

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.

12 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

NULL handling in QlikView

-Rob

View solution in original post

Highlighted
Specialist
Specialist

Try this

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

Highlighted
Contributor III
Contributor III

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"