topic Re: How can I freeze the 'total' column on a pivot chart? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072829#M935312 <HTML><HEAD></HEAD><BODY><P>What if you move it to the top instead of bottom? It will always show at the top? You can do that on the Presentation tab of the chart properties</P></BODY></HTML> Fri, 19 Feb 2016 14:17:48 GMT sunny_talwar 2016-02-19T14:17:48Z How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072828#M935311 <HTML><HEAD></HEAD><BODY><P>I have a pivot table which uses a scrollbar to view all dimensions (spread over columns). Is there a way fro me to freeze the total column, so that scrolling doesn't affect it?</P><P></P><P>Similar to freezing panes in Excel.</P></BODY></HTML> Fri, 19 Feb 2016 13:28:22 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072828#M935311 nikita42 2016-02-19T13:28:22Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072829#M935312 <HTML><HEAD></HEAD><BODY><P>What if you move it to the top instead of bottom? It will always show at the top? You can do that on the Presentation tab of the chart properties</P></BODY></HTML> Fri, 19 Feb 2016 14:17:48 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072829#M935312 sunny_talwar 2016-02-19T14:17:48Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072830#M935313 <HTML><HEAD></HEAD><BODY><P>I have one set of totals as a single column, and another along a single row/multiple columns. Both are set to be on top in the presentation tab. When I scroll left to right, my totals column is out of view. I want it to stay static like my dimension column, even when scrolling.</P></BODY></HTML> Fri, 19 Feb 2016 14:24:07 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072830#M935313 nikita42 2016-02-19T14:24:07Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072831#M935314 <HTML><HEAD></HEAD><BODY><P>Do you have a sample you can share?</P></BODY></HTML> Fri, 19 Feb 2016 16:55:48 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072831#M935314 sunny_talwar 2016-02-19T16:55:48Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072832#M935315 <HTML><HEAD></HEAD><BODY><P>In the attached QVW, I have a pivot table showing the headcount of different functions across cities. When I scroll from left to right, I don't want the total (function) column to move. I want to freeze it with the function column.</P></BODY></HTML> Mon, 22 Feb 2016 10:07:10 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072832#M935315 nikita42 2016-02-22T10:07:10Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072833#M935316 <HTML><HEAD></HEAD><BODY><P>One option is to add it as a calculated dimension. Performance can suffer if you have large dataset in this case</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115438_Capture.PNG" style="height: 157px; width: 620px;" /></P></BODY></HTML> Mon, 22 Feb 2016 10:17:45 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072833#M935316 sunny_talwar 2016-02-22T10:17:45Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072834#M935317 <HTML><HEAD></HEAD><BODY><P>or u can create a empty dimension wit "0"&nbsp; also</P></BODY></HTML> Mon, 22 Feb 2016 10:20:46 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072834#M935317 Chanty4u 2016-02-22T10:20:46Z Re: How can I freeze the 'total' column on a pivot chart? https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072835#M935318 <HTML><HEAD></HEAD><BODY><P>What is an empty dimension? Could you please clarify how this will freeze the total column?</P></BODY></HTML> Mon, 22 Feb 2016 10:48:21 GMT https://community.qlik.com/t5/QlikView/How-can-I-freeze-the-total-column-on-a-pivot-chart/m-p/1072835#M935318 nikita42 2016-02-22T10:48:21Z