Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ronman10
New Contributor III

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

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

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
New Contributor III

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

Community Browser