topic Re: Null value. in Qlik Learning Discussions

Null value.

Mon, 20 Oct 2014 14:22:15 GMT

I have value 1 and - for a dimension called flag. The - is equivalent to null which is the result of left join I have performed. How do I check the - in set analysis to create an expression?

Appreciate any help around this. I read several discussions related to this but nothing helped.

Thanks

Re: Null value.

MK_QSL — Mon, 20 Oct 2014 14:24:21 GMT

What type of expression you want? Kindly elaborate little more !

Re: Null value.

Mon, 20 Oct 2014 14:27:08 GMT

Expression I'm looking for is simple. To check the dimension for null value or - and sum the sales.

Re: Null value.

MK_QSL — Mon, 20 Oct 2014 14:34:25 GMT

Consider you have below data....

Load * Inline

[

Customer, Sales, Flag

A, 10, -

B, 100, 1

C, 50,

D, 40, 1

E, 200,

];

In Text Box, use below expressions.

=SUM(Sales)

Will give you total Sales

=SUM({<Flag = {"=Len(Trim(Replace(Flag,'-','')))>0"}>}Sales)

Will give you SUM(Sales) where Flag is not Null or not -....

=SUM({<Flag = {"=Len(Trim(Replace(Flag,'-','')))=0"}>}Sales)

Will give you SUM(Sales) where Flag = null or -