topic Re: Hide column in pivot table and just display the in total column in QlikView https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218847#M71912 <HTML><HEAD></HEAD><BODY><P>Hi Gloria</P><P></P><P>I've got exactly the same problem to solve, Have you found a solution by now?</P><P></P><P>Regards</P><P>Rainer</P></BODY></HTML> Mon, 06 May 2013 11:30:41 GMT 2013-05-06T11:30:41Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218840#M71905 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am making a sales forecast pivot table by customer (dimension), month (dimension). We have two expressions (sales figure, %).</P><P>I just want to show % in the partial sum total column but hide in the month column. Is there any way to do it and how?</P><P>My QV version is still 8.5. Not yet up to 9.</P><P>Thanks in advance.</P><P>Gloria</P></BODY></HTML> Thu, 21 Jan 2010 10:03:04 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218840#M71905 2010-01-21T10:03:04Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218841#M71906 <HTML><HEAD></HEAD><BODY><P>You can make the table Fast Change type with Straight and Pivot, and when it is displayed as Straight Table then go to chart properties, Presentation tab, there you can check the Hide Column or even make it conditional.</P></BODY></HTML> Thu, 21 Jan 2010 10:46:48 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218841#M71906 2010-01-21T10:46:48Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218842#M71907 <HTML><HEAD></HEAD><BODY><P>I have ticked Hide Column in Straight Table, however, when I change back to Pivot Table view, the column is still appearing.</P><P>Also, is 8.5 supports hide column to be conditional?</P></BODY></HTML> Thu, 21 Jan 2010 11:04:11 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218842#M71907 2010-01-21T11:04:11Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218843#M71908 <HTML><HEAD></HEAD><BODY><P>Hi, here's an example demostrate my problem. Please help~~ Many thanks.</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5353.sales.JPG"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/5353.sales.JPG" /></A></P></BODY></HTML> Wed, 27 Jan 2010 16:07:35 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218843#M71908 2010-01-27T16:07:35Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218844#M71909 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I don't know if i understand you right, but if you go to the expression, there you mark %, and take away the enable.</P><P>best regards</P><P>Malin</P><P></P></BODY></HTML> Wed, 27 Jan 2010 16:38:01 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218844#M71909 2010-01-27T16:38:01Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218845#M71910 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>If I uncheck the enable in the % expression, I couldn't see the % in Total (The last column) as well. I need to have the % Total at the end but not needed on month level.</P></BODY></HTML> Thu, 28 Jan 2010 02:49:42 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218845#M71910 2010-01-28T02:49:42Z Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218846#M71911 <HTML><HEAD></HEAD><BODY><P>I want to do that in pivot table. Any idea how to do that?</P></BODY></HTML> Fri, 17 Sep 2010 13:24:33 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218846#M71911 2010-09-17T13:24:33Z Re: Hide column in pivot table and just display the in total column https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218847#M71912 <HTML><HEAD></HEAD><BODY><P>Hi Gloria</P><P></P><P>I've got exactly the same problem to solve, Have you found a solution by now?</P><P></P><P>Regards</P><P>Rainer</P></BODY></HTML> Mon, 06 May 2013 11:30:41 GMT https://community.qlik.com/t5/QlikView/Hide-column-in-pivot-table-and-just-display-the-in-total-column/m-p/218847#M71912 2013-05-06T11:30:41Z