topic Re: Send to excel brings the totals row to the top of straight table in QlikView https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849950#M298167 <HTML><HEAD></HEAD><BODY><P>Clever, This seems to work with one expression, any fix for tables with multiple expressions?</P></BODY></HTML> Mon, 08 Jun 2015 18:47:16 GMT srchilukoori 2015-06-08T18:47:16Z Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849946#M298163 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a straight table, where I'm showing the totals of the expressions on the last row on the QV application. When I send this chart to excel (send to excel option) the totals rows is moved to the top of the chart in the excel file. </P><P></P><P>I'm using QV 11.2 SR 11, Please let me know if there is a fix for this.</P><P></P><P>Thanks much.</P></BODY></HTML> Mon, 08 Jun 2015 17:53:44 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849946#M298163 srchilukoori 2015-06-08T17:53:44Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849947#M298164 <HTML><HEAD></HEAD><BODY><P>update:</P><P>We upgraded from 11 SR2 to 11.2 SR 11, the totals row format was working fine in 11 SR2.</P></BODY></HTML> Mon, 08 Jun 2015 17:55:44 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849947#M298164 srchilukoori 2015-06-08T17:55:44Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849948#M298165 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">It´s a known issue,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">At your expression mark as "No Totals"</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Using the tab Dimension Limits, please check "Show Total"</P></BODY></HTML> Mon, 08 Jun 2015 18:18:00 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849948#M298165 Clever_Anjos 2015-06-08T18:18:00Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849949#M298166 <HTML><HEAD></HEAD><BODY><P>Thank you Clever, it fixed the issue.</P></BODY></HTML> Mon, 08 Jun 2015 18:34:26 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849949#M298166 srchilukoori 2015-06-08T18:34:26Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849950#M298167 <HTML><HEAD></HEAD><BODY><P>Clever, This seems to work with one expression, any fix for tables with multiple expressions?</P></BODY></HTML> Mon, 08 Jun 2015 18:47:16 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849950#M298167 srchilukoori 2015-06-08T18:47:16Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849951#M298168 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You need to select each expression and check 'No Totals' option</P><P></P><P>Regards,</P><P>Varun</P></BODY></HTML> Mon, 08 Jun 2015 18:59:15 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849951#M298168 varunreddy 2015-06-08T18:59:15Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849952#M298169 <HTML><HEAD></HEAD><BODY><P>Using your sample and 3 expressions</P><P><IMG alt="Capturar.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88710_Capturar.PNG" style="height: 166px; width: 620px;" /></P></BODY></HTML> Mon, 08 Jun 2015 20:02:02 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849952#M298169 Clever_Anjos 2015-06-08T20:02:02Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849953#M298170 <HTML><HEAD></HEAD><BODY><P>I am experiencing the same issue while exporting from accesspoint.</P><P>I have a chart / straight table. </P><P>I understand when you say 'No totals' on the expression but the columns that i want the totals for are not a dimension on my chart. They are only as expression and hence do not appear in the list on Dimension Limits tab .</P><P>How do I get around this to show totals on the bottom .</P><P>Thanks</P></BODY></HTML> Thu, 10 Dec 2015 09:58:23 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849953#M298170 2015-12-10T09:58:23Z Re: Send to excel brings the totals row to the top of straight table https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849954#M298171 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>This seems to be fixed in SR13.</P><P></P><P>JT</P></BODY></HTML> Fri, 18 Dec 2015 09:20:01 GMT https://community.qlik.com/t5/QlikView/Send-to-excel-brings-the-totals-row-to-the-top-of-straight-table/m-p/849954#M298171 janterje 2015-12-18T09:20:01Z