topic Re: Total should be same in pivot tables for different dimensions in QlikView

Total should be same in pivot tables for different dimensions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I want total of all the stores on the basis of different dimensions to be same in a pivot chart

vishalarote — Tue, 24 Apr 2018 06:33:34 GMT

Go to Properties->Presentation->Show Partial Sum

on that checkbox show Partial sum for each dimention

vishalarote — Tue, 24 Apr 2018 06:35:17 GMT

And Also on Subtotal at Bottom Checkbox for the same path

Anonymous — Tue, 24 Apr 2018 06:46:33 GMT

The total of each pivot tables (gender and dist channel ) chart should be same ie total stores should be 408 for each dimension in pivot table

Anonymous — Thu, 26 Apr 2018 04:27:33 GMT

I want NSV value for different charts to be same like

for eg-

In image below NSV value for before previous year is 5436.2 where dimension is Dist Channel

whereas NSV value for before year is 3769.5 where dimension is gender

so,I want values for both NSV should be same

Anonymous — Thu, 26 Apr 2018 04:36:36 GMT

Please check the image and figures circled in black