Aggr and Set analysis for YoY analysis

sravankv — Sat, 16 Nov 2024 03:46:31 GMT

Hi All,

I have a report which should show year over year analysis for selected month.

below formula works perfectly fine i.e. selected moth and all previous year from selected year.

Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
[Aging Hours])

But, when i apply aggr to above formula it is showing only selected moth and year(not giving data for previous years).

=Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
			Aggr(sum([Aging Hours]),Number,State,Group,Name))

appreciate your support in resolving.

Regards,

Sravan

Re: Aggr and Set analysis for YoY analysis

Anil_Babu_Samineni — Wed, 24 Apr 2019 12:44:04 GMT

Perhaps this?

=Sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}
Aggr(sum({<fiscalmonthnbr={"$(=max(fiscalmonthnbr))"}, Year={"<=$(=max(Year))"}, [State]-={'Cancelled'}>}[Aging Hours]),Number,State,Group,Name))

topic Aggr and Set analysis for YoY analysis in QlikView

Aggr and Set analysis for YoY analysis

Re: Aggr and Set analysis for YoY analysis