Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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