Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
ronman10
Contributor

Expression to see dynamic growth of Avg. Selling Price

Hello Everyone,

I am trying to add growth rates with respect to the Avg. Selling Price (ASP=Value/Volume) of our product, for the years 2015-2018. When I select years 2015 & 2016, I need to be able to see 2016 ASP growth over 2015 ASP and so on. The data has been entered in ascending order. I tried to apply the formula, Sum(Value/Volume)/Above(Sum(Value/Volume)) - 1, but it does not seem to be working. Attached is a sample  QVF where I have used one of the formulas I found in the community. Please let me know the right expression.

Regards,

Rony

1 Solution

Accepted Solutions
ogautier62
Valued Contributor II

Re: Expression to see dynamic growth of Avg. Selling Price

hi,

just a remark :

your average is sum(value) / sum(volume) no ?

which is different from sum(value/volume)

regards

View solution in original post

3 Replies
ogautier62
Valued Contributor II

Re: Expression to see dynamic growth of Avg. Selling Price

hi,

just a remark :

your average is sum(value) / sum(volume) no ?

which is different from sum(value/volume)

regards

View solution in original post

rangam_s
Contributor II

Re: Expression to see dynamic growth of Avg. Selling Price

The expression you have used is correct. However, you see 0 % since the previous year number is matching with current year numbers (no change).

Try with different numbers then you see the change.

Small suggestion, each and every product will have different ASP, so trying to show it by year is not correct. Use product as well as dimension then it will make more accurate.

or

Calculate ASP by product then sum it for that particular year.

Hope this helps.

ronman10
Contributor

Re: Expression to see dynamic growth of Avg. Selling Price

Hi Oliver,

This worked. Here is the expression I used. (Sum(VALUE)/Sum(VOLUME))/Above (Sum(VALUE)/Sum(VOLUME))-1


Thanks everyone for your help.

Regards,

Rony