topic Re: Qlikview - AND Condition in QlikView

Qlikview - AND Condition

imtiazgirach — Sat, 16 Nov 2024 03:44:03 GMT

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

Re: Qlikview - AND Condition

sunny_talwar — Fri, 26 Apr 2019 14:46:53 GMT

May be this

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

Re: Qlikview - AND Condition

imtiazgirach — Fri, 26 Apr 2019 14:53:19 GMT

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

Re: Qlikview - AND Condition

sunny_talwar — Fri, 26 Apr 2019 15:07:32 GMT

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

Re: Qlikview - AND Condition

Anil_Babu_Samineni — Fri, 26 Apr 2019 15:08:48 GMT

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