Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export to Excel: Total of Straight Table always on Top

When I define a straight table I can define whether the totals are on first or on last row

    

Exporting to Excel  of a straight table always brings total on top

when I set "Total "under Dimension Limits it shows correct (first or last row)

(but I cannot define sum of rows for some expressions which i need)

Display                                Excel

is there a chance to get the desired result without using total under Dimension limit?

We are using Qlivkew 11.20 SR12

Any feedback is highly appreciated

1 Reply
canoebi99
Partner - Creator
Partner - Creator

Hi Rudolf,

I found this was introduced in SR12 and it is a known issue.

At your expression mark as "No Totals"

Using the tab Dimension Limits, please check "Show Total"

or upgtade to v12 as it seems to be fixed again in the first release of v12.