Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
imtiazgirach
Contributor III
Contributor III

Qlikview - AND Condition

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

Labels (3)
4 Replies
sunny_talwar

May be this

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

imtiazgirach
Contributor III
Contributor III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful