topic Calculate Average from current Quarter in QlikView

Calculate Average from current Quarter

rfigueroa — Sat, 16 Nov 2024 02:53:40 GMT

Hi, Im trying to get the correct value in the sample below

RoE = SUM(NetProfit) / SUM(Capital) * 12

And "Avg RoE" needs to be AVG(RoE) for the current Quarter,

ie: the correct value for 2018/Q1 = AVG(47.7, 89.3, 36.1) = 57.7%

I have try with Aggr, and RangeAvg( Before...) without success

How can I achieve this?

Thanks in advance

agni_gold — Sat, 27 Jul 2019 20:44:19 GMT

Change you Avg ROE expression to below :

=Avg(
Aggr(
(Sum( {<ID_Class = {5}>} Balance)
/
Sum( {<Class = {'Patrimonios'}>} Balance)
* 12),Month))

see attached file

rfigueroa — Tue, 30 Jul 2019 00:16:03 GMT

Thank You