topic Re: How do i included null value in expression in QlikView

How do i included null value in expression

ashis — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How do i included null value in expression

ridone_ — Wed, 31 Jul 2019 09:41:17 GMT

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

Re: How do i included null value in expression

martinpohl — Wed, 31 Jul 2019 09:45:36 GMT

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

Re: How do i included null value in expression

ashis — Wed, 31 Jul 2019 10:10:46 GMT

Hi Martin,

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

It was good idea though.

Re: How do i included null value in expression

ashis — Wed, 31 Jul 2019 10:12:44 GMT

Hi Ridone,

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

Re: How do i included null value in expression

ashis — Wed, 31 Jul 2019 10:16:54 GMT

Hi Martin,

Sorry my bad , it worked . Thank you.