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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sridhar_sigired
Creator
Creator

Summary at top while importing table into excel

Hi Experts,

My user is trying to exports straight table into excel and the summary (totals) are exporting at TOP instead of BOTTOM of chart, though in dashboard they are available at BOTTOM.

But if he prints then it is showing at BOTTOM as available in dashboard.

We want even TOTALS should show at bottom of report while exporting into excel.

Do we have any setting to change this?

Thanks for your time.

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Hi,

Try this

At your expression mark as "No Totals"

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

View solution in original post

6 Replies
Chanty4u
MVP
MVP

Hi,

Try this

At your expression mark as "No Totals"

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

Not applicable

Change the settings in Expression tab.

Capture.JPG

vardhancse
Specialist III
Specialist III

Hi,

change the settings in properties so show as per the requirement

Chart->Properties->Presentation.

sridhar_sigired
Creator
Creator
Author

Hi,

My problem is not with the chart presentation. Chart is showing total at bottom only. But while exporting, it is exporting at top.

sridhar_sigired
Creator
Creator
Author

Hi,

My problem is not with the chart presentation. Chart is showing total at bottom only. But while exporting, it is exporting at top.

Chanty4u
MVP
MVP

which version your using? 

its bug in Qv11.2

its working fine in QV12