topic Include Isnull in setanalysis in QlikView

Include Isnull in setanalysis

bharatkishore — Thu, 17 Mar 2016 06:12:52 GMT

Hi All,

I have the following expression.

=Sum({<days={">=5 <10"}>}[LC2 Amount])

I want to add isnull into this expression.

I have tried this expression:

=Sum({<days={">=5 <10"}>}if(isnull([Clrng doc]),[LC2 Amount]))

But there value is not matching. If i click on the filter then the value is matching.

Is there anything wrong in my expression.

Thanks,

R. Bharat Kishore

bharatkishore — Thu, 17 Mar 2016 06:16:19 GMT

Sorry i have got this..

Chanty4u — Thu, 17 Mar 2016 06:17:42 GMT

try single quotes

=Sum({<days={'>=5 <10'}>}if(isnull([Clrng doc]),[LC2 Amount]))