Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
karunaramteke
Contributor III
Contributor III

To get TOTAL at bottom when I export

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

1 Solution

Accepted Solutions
MK9885
Master II
Master II

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'

2020-08-03_112947.png

View solution in original post

2 Replies
karunaramteke
Contributor III
Contributor III
Author

Nobody can help me in this ??

 

MK9885
Master II
Master II

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'

2020-08-03_112947.png