6 Replies Latest reply: Apr 18, 2017 5:34 PM by David Hanaway

# Problem with price-volume analysis

In my data model products are grouped into brands and I have built pivot table where I am analysing price/volume variances:

The formulas which are behind Price and Volume effects are as following:

Volume effect =([QTY CY]-[QTY PY])*[PY YTD]/[QTY PY]/[PY YTD]

Price effect =(([CY YTD]/[QTY CY])-([PY YTD]/[QTY PY]))*[QTY CY]/[PY YTD]

where CY - current year, PY - previous year

expression is calculated correctly only on product level and is wrong at Brand total level (illustrated in excel file attached). How can I implement PVM formula to show correct +6% effect of total brand level?

• ###### Re: Problem with price-volume analysis

This might helps you else attach a sample qv of yours

• ###### Re: Problem with price-volume analysis

Thank you,Sivaraj. It is really close to the right value however not exactly 6%. Unfortunately my model is big, your example is a good representaion. Is there a way to use aggr function for that?

• ###### Re: Problem with price-volume analysis

Do you still need a way to do this, we have recently completed a pvmc in qlikview, and just thought I would see if you still needed some direction or help?

• ###### Re: Problem with price-volume analysis

Rhonda,

We are just starting down the road doing PVM calculations in Qlikview.  I would like to see your sanitized example if you are still willing to share.

Thx

• ###### Re: Problem with price-volume analysis

Hi Nikita,my company is an OEM partner to Qlik, and this is exactly what we do.  If you are interested in discussing further, please feel free to write me at dtandon@thekinigroup.com. You can also find out more information at our website, https://thekinigroup.com.  Thank you!

Dev Tandon

The Kini Group

http://www.thekinigroup.com

• ###### Re: Problem with price-volume analysis

Was anyone able to find a solution to the issue? I am having the exact same problem?

I am using a pivot table and at the material level the values calculate properly. I want to be able to sum the calculated values at the material level, as opposed to using the same formula for the total. Is there anyway to do this?