Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
srchilukoori
Specialist
Specialist

Send to excel brings the totals row to the top of straight table

Hi,

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.

I'm using QV 11.2 SR 11, Please let me know if there is a fix for this.

Thanks much.

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

It´s a known issue,

At your expression mark as "No Totals"

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

View solution in original post

8 Replies
srchilukoori
Specialist
Specialist
Author

update:

We upgraded from 11 SR2 to 11.2 SR 11, the totals row format was working fine in 11 SR2.

Clever_Anjos
Employee
Employee

It´s a known issue,

At your expression mark as "No Totals"

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

srchilukoori
Specialist
Specialist
Author

Thank you Clever, it fixed the issue.

srchilukoori
Specialist
Specialist
Author

Clever, This seems to work with one expression, any fix for tables with multiple expressions?

varunreddy
Creator III
Creator III

Hi,

You need to select each expression and check 'No Totals' option

Regards,

Varun

Clever_Anjos
Employee
Employee

Using your sample and 3 expressions

Capturar.PNG

Not applicable

I am experiencing the same issue while exporting from accesspoint.

I have a chart / straight table.

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 .

How do I get around this to show totals on the bottom .

Thanks

janterje
Partner - Contributor III
Partner - Contributor III

Hi.

This seems to be fixed in SR13.

JT