topic Re: Dynamic Period over Period Comparison in a Pivot Table ? in QlikView

Dynamic Period over Period Comparison in a Pivot Table ?

bob654321 — Wed, 17 Jul 2019 14:33:27 GMT

I'm trying to compare the sales for the months selected and the same months for the previous year and add a sales variance percentage as a new column at the end. When I tried to do its, the variance is repeating for each month. I only want to display the sales variance between current month & current month of last year at the very end of the pivot table. How to do it in Qlikview ? I have attached a sample spreadsheet of the layout.

Re: Dynamic Period over Period Comparison in a Pivot Table ?

qliksus — Thu, 18 Jul 2019 08:45:54 GMT

Enable the Partial sum option for the fist dimension in your pivot table and name the label for total as Variance% and create a expression like the below

If ( dimensionality()=0 , Sum(CMSALES)/sum(PREMonthsales) , Sum(sales))

Re: Dynamic Period over Period Comparison in a Pivot Table ?

bob654321 — Thu, 18 Jul 2019 13:57:50 GMT

Do you have a sample qvw to show this ?

Re: Dynamic Period over Period Comparison in a Pivot Table ?

qliksus — Fri, 19 Jul 2019 03:38:03 GMT

I cant attach any file form my environment Let me detail you the steps

1) Go to the presentation tab in the pivot chart and enable the "Show Partial sum " option for the first dimension

2) In the "label for Total" enter Variance%

3) Go to the expression tab and type if ( Dimensionality() = 0 , Sum(lasmonsales)/Sum(currenmonsales) , Sum( sales) )

Re: Dynamic Period over Period Comparison in a Pivot Table ?

Brett_Bleess — Mon, 12 Aug 2019 16:01:32 GMT

Did the posters last reply help you get what you needed working? If so, please be sure to give them credit by clicking the Accept as Solution button on the post. If you are still struggling with things, please provide an update, or if you used a different solution, you can post that and mark it as the accepted solution as well to give any future readers more ideas.

Regards,
Brett