Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using set analysis:
=Sum({<APHold.OpenFlag = {'Y'}>} APhold.count)
May be using set analysis:
=Sum({<APHold.OpenFlag = {'Y'}>} APhold.count)
Excellent, thank you for your assistance much appreciated!
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