Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ronman10
Creator
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
ogautier62
Specialist II
Specialist II

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

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
Creator II
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.

ronman10
Creator
Creator
Author

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