Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
hi , kindly check below sanp shot and uncheck the supress zero Value, this might work correct me if iam wrong
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
Hi Martin,
Thank you for your quick reply. I tried your logic however it is not matching my number.
It was good idea though.
Hi Ridone,
I am using it in QLIKSENSE KPI. Sorry i did not mentioned it in my post earlier.
Hi Martin,
Sorry my bad , it worked . Thank you.