topic Re: To get TOTAL at bottom when I export in QlikView

To get TOTAL at bottom when I export

karunaramteke — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am using straight table and in expression I am writing =Only({<MODULE_ID={'117'}>}Voucher_Count)

I want the total to come at the last row.

I had did that from presentation, Total is coming at last row in chart, but when I export the chart, total comes in first row, also two times I can see total written.

Also, I tried , In expression mark as "No Totals" and Used the tab Dimension Limits, check "Show Total"

I am having 2 dimensions.

Please suggest

Please find attachment how I am getting the output currently.

Please find output that i am getting currently.please help me to get the total in last row when I export the chart

Re: To get TOTAL at bottom when I export

karunaramteke — Thu, 30 Jul 2020 11:26:58 GMT

Nobody can help me in this ??

Re: To get TOTAL at bottom when I export

MK9885 — Mon, 03 Aug 2020 15:30:41 GMT

Go to 'Presentation Tab'

Select your Column 'Day' and on bottom right, Check 'Totals on Last Row' -You can add label too if you want.

Also to avoid multiple TOTALS, In 'Dimension Limits Tab' Uncheck 'Show Total'