topic Re: previous 3 months avg in QlikView

previous 3 months avg

Mon, 09 Mar 2015 11:28:45 GMT

Hi All,

please help to calculate last 3 months of avg. in pivot table.

thanks,

Raja

arulsettu — Mon, 09 Mar 2015 11:35:19 GMT

for example calculating last 3 month sales average

avg({<month={$(=max(month)-3)}>}sales)

arulsettu — Mon, 09 Mar 2015 11:37:43 GMT

=avg({<month={">=$(=max(month))<=$(=max(month)-3)"}>}sales)

manideep78 — Mon, 09 Mar 2015 11:48:11 GMT

Avg({<month={">=$(=max(month)-3)<$(=max(month))"}>}Sales)