How to add a filter to an expression?

[#1]

Hi,

I basically want an expression created to measure the amount of invoices on a financial system with active holds placed upon them. The expression I need goes along the lines of.....

=sum(APhold.count) where APHold.OpenFlag = Y

However I am unable to get the expression to work!?!

Any advice would be great.

Thank you

[sunny_talwar · Accepted solution]

May be using set analysis:

=Sum({<APHold.OpenFlag = {'Y'}>} APhold.count)

[#3]

Excellent, thank you for your assistance much appreciated!

[sunny_talwar]

No problem. If your question is resolved now, I would suggest you to close this thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny