Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrjohn23
Creator III
Creator III

Send to Excel

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?

1 Solution

Accepted Solutions
mrjohn23
Creator III
Creator III
Author

I figured it out. The problem was in the Expressions tab I needed to select Total Mode to No totals!

View solution in original post

7 Replies
Clever_Anjos
Employee
Employee

Would you mind posting a screenshot?

vcanale
Partner
Partner

Hi,
what if you export in .csv?
same issue??

mrjohn23
Creator III
Creator III
Author

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

mrjohn23
Creator III
Creator III
Author

See attached for example. If I send the chart to excel the totals row displays on the top row and not the bottom row.

mrjohn23
Creator III
Creator III
Author

I figured it out. The problem was in the Expressions tab I needed to select Total Mode to No totals!

vcanale
Partner
Partner

If the row is empty (so you do not have any Total), just select "No Totals" in the Expressions tab

mrjohn23
Creator III
Creator III
Author

Check your chart properties. Expressions-->Total Mode--->Select No Totals (of course if you do not need totals). Then you can select Column totals via the Presentation tab.