topic Dimension Partial Sum Suppress in QlikView https://community.qlik.com/t5/QlikView/Dimension-Partial-Sum-Suppress/m-p/1144476#M912126 <HTML><HEAD></HEAD><BODY><P>Using Qlikview 11</P><P>I have Pivot table with several cyclic group dimensions and partial sum is shown one on some of these dimensions.</P><P>The question is can I give the user option to suppress the dimension totals row when they want in other words suppress dimension total when user wants.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Dimension Partial Sum Suppress https://community.qlik.com/t5/QlikView/Dimension-Partial-Sum-Suppress/m-p/1144476#M912126 <HTML><HEAD></HEAD><BODY><P>Using Qlikview 11</P><P>I have Pivot table with several cyclic group dimensions and partial sum is shown one on some of these dimensions.</P><P>The question is can I give the user option to suppress the dimension totals row when they want in other words suppress dimension total when user wants.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dimension-Partial-Sum-Suppress/m-p/1144476#M912126 Anonymous 2020-11-25T16:16:04Z Re: Dimension Partial Sum Suppress https://community.qlik.com/t5/QlikView/Dimension-Partial-Sum-Suppress/m-p/1144477#M912127 <HTML><HEAD></HEAD><BODY><P>The partial sum option for a dimension is not controlled by an expression (for example like a conditional expression / dimension), so I think you can only</P><P>a) use Macro code to control the partial sums (which is not recommended)</P><P>b) maybe use different charts / dimensions with show conditions for the chart / conditional on dimension tab</P></BODY></HTML> Tue, 07 Jun 2016 18:07:55 GMT https://community.qlik.com/t5/QlikView/Dimension-Partial-Sum-Suppress/m-p/1144477#M912127 swuehl 2016-06-07T18:07:55Z