Discussion Board for collaboration related to QlikView App Development.
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
View solution in original post
Please check this link -
YoY (Year over year growth) by 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.
I read your post correctly. It solved.