Excluding data outside of criteria in expression

[#1]

Hello, I am using expression :- if(NetWorkDays(max(BA_Contact_Date),max(Posting_Date))>'0'
and NetWorkDays(max(BA_Contact_Date),max(Posting_Date))<='4',money([Sum Paid]*-1))

This expression works just fine if data falls within the criteria. However if the posting date is more than 5 days after BA_Contact_Date the whole expression returns null. is there a way to force it to only to look at the data within specified criteria?

paul.

[#2]

where You use this expression?

[#3]

In Qlikview

[#4]

In an expression in a straight table

[#5]

Any ideas please? I'm still stuck!

[SunilChauhan]

Try below code

while comparing number should not be written in singal quote

if(NetWorkDays(max(BA_Contact_Date),max(Posting_Date))>0
and NetWorkDays(max(BA_Contact_Date),max(Posting_Date))<=4,money([Sum Paid]*-1))

hope this helps

[#7]

No this had no impact, I am still getting Null as output as there are dates and amount outside of the expression criteria, it cant decide to chose (despite the fact the expression is explicit)therefore I am getting a null. No idea why this is the case!

[SunilChauhan]

charts properties -> presentation->supress zero values check it

if not please attach sample file if possible

hope this helps