Month wise Growth in percent (Current Year, Previous Year and so on)

[nayanpatel]

Hi friends,

I am looking for the formula to show month-wise growth %  in the Pivot table or table in Qlik sense.

PFA image which I need to develop in Qlik sense. Here, in Image, it shows % value compared with the previous year on year and with months (Month wise)

Please help. 

Thank you.

Nayan

[JordyWegman]

Hi  Nayanpatel,

Try something like this:

Sum(Above(Total Sales)) / Sum(Sales) 

Jordy

Climber 

[nayanpatel]

Hi Jordy,

Thank you for the response. However, this is not working

[sunny_talwar]

Are you comparing Feb 2019 to Feb 2018 or are you comparing Feb 2019 to Jan 2019? Also, what is the expression for quantity? Just Sum(qty)?

[nayanpatel]

Hi Sunny,

Thank you for the response.

I am comparing

1. Jan 2017 to Jan 2018, Feb 2017 to Feb 2018 and so on

2. Then Jan 2018 to Jan 2019, Feb 2018 to Feb 2019 and so on as in Image given format

Kindly help

Thanks you

Nayan

[sunny_talwar]

May be something like this

Sum(Qty)/Below(Sum(Qty))

[nayanpatel]

Hi Sunny,

It should be like what you have given. however, this is not working

Please let me know if you find something to achieve the required output

Thank you

[sunny_talwar]

Would you be able to share a sample where we can see the issue?