topic Re: Sub total in pivot table in QlikView https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015332#M929993 <HTML><HEAD></HEAD><BODY><P>can u share sample?</P></BODY></HTML> Thu, 17 Mar 2016 12:27:04 GMT Chanty4u 2016-03-17T12:27:04Z Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015331#M929992 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My pivot table having 2-dimensions</P><P></P><P><STRONG>State</STRONG> and <STRONG>city</STRONG> and my expression is <STRONG>count(Distinct Appnum)</STRONG></P><P></P><P>In presentation i have check show partial sum for both dimensions but for city some othem were showing sub total and some of them weren't showing sub total.Kindly help on this.</P><P></P><P>Thanks..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015331#M929992 nareshthavidishetty 2020-11-25T16:16:04Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015332#M929993 <HTML><HEAD></HEAD><BODY><P>can u share sample?</P></BODY></HTML> Thu, 17 Mar 2016 12:27:04 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015332#M929993 Chanty4u 2016-03-17T12:27:04Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015333#M929994 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">try </STRONG></P><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">= Count(Aggr(Distinct Appnum))</STRONG></P></BODY></HTML> Thu, 17 Mar 2016 12:29:45 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015333#M929994 Chanty4u 2016-03-17T12:29:45Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015334#M929995 <HTML><HEAD></HEAD><BODY><P>do you have <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Appnum for all the city ??? is not then due to null values the partial sum may not be displaying </STRONG></P></BODY></HTML> Thu, 17 Mar 2016 12:31:36 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015334#M929995 avinashelite 2016-03-17T12:31:36Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015335#M929996 <HTML><HEAD></HEAD><BODY><P>plz share the sample data..</P></BODY></HTML> Mon, 21 Mar 2016 09:17:19 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015335#M929996 Anonymous 2016-03-21T09:17:19Z Re: Sub total in pivot table https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015336#M929997 <HTML><HEAD></HEAD><BODY><P>If you have the "Suppress Zero-Values" option checked, then zero partial sums will be suppressed as well. Uncheck the option to see the zero partial sums.</P></BODY></HTML> Mon, 21 Mar 2016 09:26:27 GMT https://community.qlik.com/t5/QlikView/Sub-total-in-pivot-table/m-p/1015336#M929997 jonathandienst 2016-03-21T09:26:27Z