topic Help Needed With Chart Title Calculation in QlikView

Help Needed With Chart Title Calculation

pnn44794 — Sat, 16 Dec 2017 21:59:46 GMT

Hello:

I'm trying to add a Count to a straight table chart / window title using the following:

=if(Phase = 'Finance Validation',Count (ID)) & ' OUTSTANDING FINANCE VALIDATIONS'

When I click Apply, the only thing that is returned for the Chart Title is OUTSTANDING FINANCE VALIDATIONS. The Count should equal 85. I'm guessing I'm missing something simple. Any ideas?

As always, thanks in advance for any and all help.

Re: Help Needed With Chart Title Calculation

Anil_Babu_Samineni — Sun, 17 Dec 2017 03:48:59 GMT

Try this way?

Count({<Phase = {'Finance Validation'}>} ID) & ' OUTSTANDING FINANCE VALIDATIONS'

Re: Help Needed With Chart Title Calculation

pnn44794 — Sun, 17 Dec 2017 20:20:08 GMT

Thank you Anil for the response. This works. Why would my syntax not work? I’m not looking for a long explanation. Just simply curious. I will mark your answer as the correct answer. Thank you for your help. I appreciate it.

Re: Help Needed With Chart Title Calculation

Anil_Babu_Samineni — Mon, 18 Dec 2017 02:06:58 GMT

Your syntax pretty works when you got filter from Phase as "Finance Validation" only until unless it won't..

Re: Help Needed With Chart Title Calculation

pnn44794 — Mon, 18 Dec 2017 22:02:14 GMT

Ah. Ok. Thank you and thanks again for your help.