topic Send to Excel in QlikView https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111309#M904532 <HTML><HEAD></HEAD><BODY><P>When I send my data from a table to Excel I always have a leading empty row inbetween the header and the first row. How can I remove this empty row? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111309#M904532 <HTML><HEAD></HEAD><BODY><P>When I send my data from a table to Excel I always have a leading empty row inbetween the header and the first row. How can I remove this empty row? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111309#M904532 Anonymous 2020-11-25T16:16:04Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111310#M904533 <HTML><HEAD></HEAD><BODY><P>Would you mind posting a screenshot?</P></BODY></HTML> Fri, 24 Jun 2016 14:15:25 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111310#M904533 Clever_Anjos 2016-06-24T14:15:25Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111311#M904534 <HTML><HEAD></HEAD><BODY><P>Hi, <BR />what if you export in .csv? <BR />same issue??</P></BODY></HTML> Fri, 24 Jun 2016 14:17:16 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111311#M904534 vcanale 2016-06-24T14:17:16Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111312#M904535 <HTML><HEAD></HEAD><BODY><P>It's the Totals row in the presentation tab. When I select totals on last row and when I send to excel it displays on the top</P></BODY></HTML> Fri, 24 Jun 2016 14:20:29 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111312#M904535 Anonymous 2016-06-24T14:20:29Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111313#M904536 <HTML><HEAD></HEAD><BODY><P>See attached for example. If I send the chart to excel the totals row displays on the top row and not the bottom row. </P></BODY></HTML> Fri, 24 Jun 2016 14:27:53 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111313#M904536 Anonymous 2016-06-24T14:27:53Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111314#M904537 <HTML><HEAD></HEAD><BODY><P>I figured it out. The problem was in the Expressions tab I needed to select Total Mode to No totals! </P></BODY></HTML> Fri, 24 Jun 2016 14:30:00 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111314#M904537 Anonymous 2016-06-24T14:30:00Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111315#M904538 <HTML><HEAD></HEAD><BODY><P>If the row is empty (so you do not have any Total), just select "No Totals" in the Expressions tab</P></BODY></HTML> Fri, 24 Jun 2016 14:32:06 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111315#M904538 vcanale 2016-06-24T14:32:06Z Re: Send to Excel https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111316#M904539 <HTML><HEAD></HEAD><BODY><P>Check your chart properties. Expressions--&gt;Total Mode---&gt;Select No Totals (of course if you do not need totals). Then you can select Column totals via the Presentation tab. </P></BODY></HTML> Fri, 24 Jun 2016 14:55:10 GMT https://community.qlik.com/t5/QlikView/Send-to-Excel/m-p/1111316#M904539 Anonymous 2016-06-24T14:55:10Z