topic Re: How can I insert an average here? in QlikView

How can I insert an average here?

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

Dears,

How can I insert an average into the following formula:

=num(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação), 'R$ 0,00')

I'm trying something like:

=num(avg(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação)), 'R$ 0,00'), but it's not working...

Thanks!

Re: How can I insert an average here?

Saravanan_Desingh — Sun, 03 May 2020 00:44:25 GMT

Can you try like this?

=Num(RangeAvg(FirstSortedValue(ValorAçãoFechamentoAjustado, -DataCotação)), 'R$ 0,00')

Re: How can I insert an average here?

brunolelli87 — Sun, 03 May 2020 04:06:54 GMT

Thanks for your assistance, but it's not working...

It's showing a dash, -

Re: How can I insert an average here?

Brett_Bleess — Tue, 26 May 2020 21:22:19 GMT

Would likely be most helpful if you can attach small example QVW file on this one, not sure anyone can be sure otherwise. This will kick things back up too given you posted on a Saturday, it likely got missed by a lot of folks.

Regards,
Brett