Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This might helps you else attach a sample qv of yours
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?
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?
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
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
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?