topic Re: Problem with price-volume analysis in QlikView

Problem with price-volume analysis

Wed, 21 Nov 2012 05:47:29 GMT

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

sivarajs — Wed, 21 Nov 2012 06:07:16 GMT

This might helps you else attach a sample qv of yours

Re: Problem with price-volume analysis

Wed, 21 Nov 2012 06:34:40 GMT

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

Tue, 07 Apr 2015 15:36:06 GMT

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

Tue, 07 Jul 2015 20:21:39 GMT

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

dtandon@thekinigroup.com

Re: Problem with price-volume analysis

johns46140 — Thu, 03 Mar 2016 01:35:32 GMT

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

Tue, 18 Apr 2017 21:34:14 GMT

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?