Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Include Isnull in setanalysis

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

1 Solution

Accepted Solutions
bharatkishore
Creator III
Creator III
Author

Sorry i have got this..

View solution in original post

2 Replies
bharatkishore
Creator III
Creator III
Author

Sorry i have got this..

View solution in original post

Chanty4u
Champion III
Champion III

try single quotes

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