topic Re: Summary at top while importing table into excel in QlikView

Summary at top while importing table into excel

sridhar_sigired — Fri, 11 Nov 2016 05:03:35 GMT

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.

Re: Summary at top while importing table into excel

Chanty4u — Fri, 11 Nov 2016 05:14:52 GMT

Hi,

Try this

At your expression mark as "No Totals"

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

Re: Summary at top while importing table into excel

Fri, 11 Nov 2016 05:17:50 GMT

Change the settings in Expression tab.

Re: Summary at top while importing table into excel

vardhancse — Fri, 11 Nov 2016 05:59:52 GMT

Hi,

change the settings in properties so show as per the requirement

Chart->Properties->Presentation.

Re: Summary at top while importing table into excel

sridhar_sigired — Fri, 11 Nov 2016 06:13:37 GMT

Hi,

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

Re: Summary at top while importing table into excel

sridhar_sigired — Fri, 11 Nov 2016 06:13:42 GMT

Hi,

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

Re: Summary at top while importing table into excel

Chanty4u — Fri, 11 Nov 2016 06:17:17 GMT

which version your using?

its bug in Qv11.2

its working fine in QV12