rangeavg

[#1]

Hi All,

Can any one explain me how this expression works. I had gone through the help but i am not able to understand. Thankful to you if some can explain here with the data and calculation here so that it is easy for newbie like me.

rangeavg(above(Sum(SalValue),0,3))

[#2]

hi

of course, it's the right formula for evolution & the same formula as you.

((current month's sales - last month's sales)/last month's sales) = current month's sales/ last month's sales - 1

Why do you multiplicate by 10 (maybe you mean by 100) but you don't need, use "show in percentage (%)' in the chart properties number.

regards

jj

[#3]

Hi JJ,

I agreed! Now i am able to recall my maths now. The formula is same as yours and probably yours will be easier to apply. Thanks a ton!

Regards,

Rikab

[#4]

Hi JJ,

I need your help in the below post. Issue is very similar to this post. Requesting you to help me out.

http://community.qlik.com/forums/t/34086.aspx

[#5]

Hi Rikab,

It looks too tricky for me.

Have a look at this post : http://community.qlik.com/forums/t/33689.aspx

John W suggests when you want to make comparison Y2Y to merge the current year with the previous year (of course with a lag of 12 months).

It should simplify the syntax in the chart.

Hope it helps you.

regards

jj