Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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:

21-11-2012 11-42-01.jpg

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?

6 Replies
sivarajs
Specialist II
Specialist II

This might helps you else attach a sample qv of yours

Not applicable
Author

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?

Not applicable
Author

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?

Not applicable
Author

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

johns46140
Contributor
Contributor

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

Not applicable
Author

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?