Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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) )
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))
Do you have a sample qvw to show this ?
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) )
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