topic How to add a filter to an expression? in QlikView

How to add a filter to an expression?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to add a filter to an expression?

sunny_talwar — Fri, 23 Sep 2016 15:22:01 GMT

May be using set analysis:

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

Re: How to add a filter to an expression?

Wed, 28 Sep 2016 13:30:32 GMT

Excellent, thank you for your assistance much appreciated!

Re: How to add a filter to an expression?

sunny_talwar — Wed, 28 Sep 2016 17:06:34 GMT

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