6 Oct 2010 Trying to figure out how to show and not show partial sums in a pivot table via a macro. I have a pivot table that allows users to add dimensions Qlik®Tech and Qlik®View are registered trademarks of QlikTech International The pivot table now shows partial sums per sales person and on year level. Making a partial sum for all dimensions. The default is that the partial. creating a pivot table, with 4 dimensions, one of which is horizontal. that selection, is there still a way to have the colomn show up but with zeros? 9 May 2016 Hi everyone, @Sunny T I want to show total zone wise where I am creating Branches with value list. Please help me with this issue. Regards 26 Jan 2017 Solved: Hi, We got a user request to allow users to show/hide partial sum on particular dimension they select. I created duplicate dimensions in. Charts and tables are one of the most integral part of Qlikview features. Charts and You'll start by creating a simple chart showing the sum of sales per country. Go to the . The pivot table now shows partial sums on year level. Creating a 26 Apr 2016 Solved: Hi Guru's, As Per My Requirement I wanted to show Partial Sums only greater than 5000 Sales Amount,but data should be visible but When you create a PivotTable that shows value amounts, subtotals and grand totals appear automatically, but you can also show or hide them. PivotTableAll Places > QlikView Forums & Resources > QlikView Creating Analytics In my example below the partial sum reads -40% when it should be +26%. I need assistance getting correct value shown on the YoY % Growth line. 16 Apr 2011