Solved: Re: Year Over Year Growth & MoM Growth % Calculat... - Qlik Community

vikasmahajan · ‎2018-01-11

HI all

I have to calculate CY-LY/LY Year wise (YOY) and MOM Wise . Dimension will be COMP -> Company & Year

Attached QVF demo file and excel.

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sunny_talwar · ‎2018-01-11

Hahahaha... did you even open this thread my friend? If you would have you would have not asked me to do something which I have already done....

Re: Year Over Year Growth & MoM Growth % Calculation in QlikSense

View solution in original post

vikasmahajan · ‎2018-01-11

Sunny can you please try and let me know

When Ascending Year

Sum(Sales)/Above(Sum(Sales)) - 1

When Descending Year

Sum(Sales)/Before(Sum(Sales)) - 1

Not able to get this ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sunny_talwar · ‎2018-01-11

Try this

Aggr(Sum(VolKL)/Above(Sum(VolKL)) - 1, COMP, (MonthYear, (NUMERIC)))

vikasmahajan · ‎2018-01-11

Can you attach qvf ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sunny_talwar · ‎2018-01-11

Hahahaha... did you even open this thread my friend? If you would have you would have not asked me to do something which I have already done....

Re: Year Over Year Growth & MoM Growth % Calculation in QlikSense

vikasmahajan · ‎2018-01-11

Sorry Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sunny_talwar · ‎2018-01-11

No problem at all.... Please mark the response which is actually correct.

Thanks,

Sunny