topic Re: How to not display Total for single row in pivot table in QS in App Development https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637873#M47551 <P>Hi,</P><P>I think you should review Dimensionality () and secondarydimensionality(), i think they'll work.</P><P>&nbsp;</P> Mon, 21 Oct 2019 14:10:09 GMT berkarmagan 2019-10-21T14:10:09Z How to not display Total for single row in pivot table in QS https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637843#M47549 <P>Hi Everyone,</P><P>I have got the below scenario-</P><P>Where the total should not display for specific row(<STRONG>internal,</STRONG> Internal is a measure used ) in pivot table.&nbsp;</P><P>Like the below,</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>&nbsp;</TD><TD>Total</TD><TD>Oct-2019</TD><TD>Sep-2019</TD><TD>Aug-2019</TD><TD>Jul-2019</TD></TR><TR><TD>Sam</TD><TD>External</TD><TD>10</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>4</TD></TR><TR><TD>&nbsp;</TD><TD>Others</TD><TD>5</TD><TD>1</TD><TD>0</TD><TD>3</TD><TD>1</TD></TR><TR><TD>&nbsp;</TD><TD><STRONG>Internal</STRONG></TD><TD><STRONG>10</STRONG></TD><TD><STRONG>5</STRONG></TD><TD><STRONG>0</STRONG></TD><TD><STRONG>2</STRONG></TD><TD><STRONG>3</STRONG></TD></TR><TR><TD>John</TD><TD>External</TD><TD>4</TD><TD>2</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>Others</TD><TD>5</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>&nbsp;</TD><TD><STRONG>Internal</STRONG></TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Desired Output-</P><TABLE border="1"><TBODY><TR><TD>Name</TD><TD>&nbsp;</TD><TD>Total</TD><TD>Oct-2019</TD><TD>Sep-2019</TD><TD>Aug-2019</TD><TD>Jul-2019</TD></TR><TR><TD>Sam</TD><TD>External</TD><TD>10</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>4</TD></TR><TR><TD>&nbsp;</TD><TD>Others</TD><TD>5</TD><TD>1</TD><TD>0</TD><TD>3</TD><TD>1</TD></TR><TR><TD>&nbsp;</TD><TD><STRONG>Internal</STRONG></TD><TD>&nbsp;</TD><TD><STRONG>5</STRONG></TD><TD><STRONG>0</STRONG></TD><TD><STRONG>2</STRONG></TD><TD><STRONG>3</STRONG></TD></TR><TR><TD>John</TD><TD>External</TD><TD>4</TD><TD>2</TD><TD>0</TD><TD>2</TD><TD>0</TD></TR><TR><TD>&nbsp;</TD><TD>Others</TD><TD>5</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>2</TD></TR><TR><TD>&nbsp;</TD><TD><STRONG>Internal</STRONG></TD><TD>&nbsp;</TD><TD><STRONG>2</STRONG></TD><TD><STRONG>0</STRONG></TD><TD><STRONG>0</STRONG></TD><TD><STRONG>0</STRONG></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>Note: - For Total I&nbsp; am selecting a slider button in Months Column.</STRONG></P><P><STRONG>Please let me know if this is possible in QS.</STRONG></P><P>&nbsp;</P><P><STRONG>Thanks in advance</STRONG></P> Sat, 16 Nov 2024 04:19:16 GMT https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637843#M47549 LP27 2024-11-16T04:19:16Z Re: How to not display Total for single row in pivot table in QS https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637873#M47551 <P>Hi,</P><P>I think you should review Dimensionality () and secondarydimensionality(), i think they'll work.</P><P>&nbsp;</P> Mon, 21 Oct 2019 14:10:09 GMT https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637873#M47551 berkarmagan 2019-10-21T14:10:09Z Re: How to not display Total for single row in pivot table in QS https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637896#M47555 <P>Yes I have heard that <SPAN>Dimensionality () and secondarydimensionality() can solve problem but not sure who to use that logic in my case.</SPAN></P><P>&nbsp;</P> Mon, 21 Oct 2019 14:42:58 GMT https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637896#M47555 LP27 2019-10-21T14:42:58Z Re: How to not display Total for single row in pivot table in QS https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637899#M47556 <P>Check this.</P><P><A href="https://community.qlik.com/t5/New-to-QlikView/dimensionality-Vs-secondarydimensionality/td-p/985587" target="_blank">https://community.qlik.com/t5/New-to-QlikView/dimensionality-Vs-secondarydimensionality/td-p/985587</A></P><P>&nbsp;</P> Mon, 21 Oct 2019 14:45:30 GMT https://community.qlik.com/t5/App-Development/How-to-not-display-Total-for-single-row-in-pivot-table-in-QS/m-p/1637899#M47556 berkarmagan 2019-10-21T14:45:30Z