Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
New Contributor III

Calculate Growth rate of sales relative to Previous month

Hi,

I want create line chart that calculate growth rate of sales relative to previous month.

it mean in dimension we have month name and in expression growth rate of sales.

for example for  year 2018:

Growth rate of sales(January-2018) = (Sales(January-2018)-Sales(December-2017))/Sales(December-2017)*100

Growth rate of sales(February-2018) = (Sales(February-2018)-Sales(January-2018))/Sales(January-2018)*100

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: Calculate Growth rate of sales relative to Previous month

4 Replies
Highlighted
Valued Contributor

Re: Calculate Growth rate of sales relative to Previous month

Please check this link -

YoY (Year over year growth) by month

Highlighted
Valued Contributor

Re: Calculate Growth rate of sales relative to Previous month

Highlighted
New Contributor III

Re: Calculate Growth rate of sales relative to Previous month

not work in my app because my date is Shamsi.

my answer is how can i put condition for dimenssion in expression?

suppose dimension have 10 value. I want calculate  expression for each value of dimension different.

Highlighted
New Contributor III

Re: Calculate Growth rate of sales relative to Previous month

hi,

I read your post correctly. It solved.

Thanak you.