How do i included null value in expression

[ashis]

Hi ,

I want to show product value including null only excluding few product name . So i am using the following syntax ,but it seems it is excluding those product names listed in the expression as well as null values.

=sum({<[Product 1]-={'A','B','C','D','E'},Rep_Field={'Current Month By Day'},Date_Period={'$(=Date(MAX(Date),'DD'))'}>}Sale)

The above code is excluding A,B,C,D,E with this it also exclude nulls. 

I AM USING THIS SYNTEX in QLIKSENSE KPI

Please help to get the correct syntax.

Thank you,

[ridone_]

hi ,  kindly check  below sanp shot and uncheck the supress zero Value,    this might work  correct me if iam wrong

[martinpohl · Accepted solution]

Hi,

the set analysis onto -={A,B,C} rewuires that there is a value in field.

null is not unequal A.

So maybe

=sum({<Rep_Field={'Current Month By Day'},Date_Period={'$(=Date(MAX(Date),'DD'))'}>}Sale)

-

sum({<[Product 1]={'A','B','C','D','E'},Rep_Field={'Current Month By Day'},Date_Period={'$(=Date(MAX(Date),'DD'))'}>}Sale)

(sum all and subtract unwanted Product1-values) 

helps

Regards

[ashis]

Hi Martin,

Thank you for your quick reply. I tried your logic however it is not matching my number. 

It was good idea though.

[ashis]

Hi Ridone,

I am using it in QLIKSENSE KPI. Sorry i did not mentioned it in my post earlier.

[ashis]

Hi Martin,

Sorry my bad , it worked . Thank you.