# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for
Did you mean:
Creator

## 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
Specialist II

hi,

just a remark :

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

which is different from sum(value/volume)

regards

3 Replies
Specialist II

hi,

just a remark :

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

which is different from sum(value/volume)

regards

Creator II

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.

Creator
Author

Hi Oliver,

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