QlikView App Dev

[mrbqlik2009]

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

[isingh30]

Please check this link -

YoY (Year over year growth) by month

[isingh30 · Accepted solution]

[mrbqlik2009]

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]

hi,

I read your post correctly. It solved.

Thanak you.