Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Qlikview - AND Condition


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)



Labels (3)
4 Replies

May be this

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

Contributor III
Contributor III

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


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


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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)