Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
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

1 Solution

Accepted Solutions
4 Replies
isingh30
Specialist
Specialist

Please check this link -

YoY (Year over year growth) by month

isingh30
Specialist
Specialist

Screen.PNG

mrbqlik2009
Contributor III
Contributor III
Author

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.

mrbqlik2009
Contributor III
Contributor III
Author

hi,

I read your post correctly. It solved.

Thanak you.