Qlikview - AND Condition

[imtiazgirach]

Hi

I want to use an AND condition like this in an expression but I am getting an error - Error in set modifier ad hoc element list.  Can anyone please suggest the correct condition to use

sum({<APHold.HoldName={'Invoice Out To Site' and IsNull(APHold.ReleaseDate)}>} APInv.InvoiceAmount)

Thanks

[sunny_talwar]

May be this

Sum({<APHold.HoldName = {'Invoice Out To Site'}*{"=IsNull(APHold.ReleaseDate)"}>} APInv.InvoiceAmount)

[imtiazgirach]

Thanks for this.  The expression is now ok but I'm not getting the desired results.

[sunny_talwar]

Would you be able to share a sample where we can see what you get and what you are trying to get?

[Anil_Babu_Samineni]

May be do this as well?

Sum({<APHold.HoldName = {"Invoice Out To Site", "=IsNull(APHold.ReleaseDate)"}>} APInv.InvoiceAmount)

If data not matches, May be logic different