Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

How do i included null value in expression

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,

1 Solution

Accepted Solutions
Partner
Partner

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

View solution in original post

5 Replies
Contributor
Contributor

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

 

presentation.PNG

Partner
Partner

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

View solution in original post

Creator III
Creator III

Hi Martin,

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

It was good idea though.

Creator III
Creator III

Hi Ridone,

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

Creator III
Creator III

Hi Martin,

Sorry my bad , it worked . Thank you.