Total row at the botttom of HTML table report

[BootCam]

Hi,

I have couple of Straight tables in my QlikSense app that are supposed to be embedded in an email. The problem is, while developing the HTML report, i am not able to bring the totals at the bottom of the straight tables from the Qliksense app. 

Not sure how to bring total from the straight table into an HTML report or how to develop that in the HTML report itself.

Could you guys help me with that?

Thanks.

[Lech_Miszkiewicz · Accepted solution]

Hi @BootCam 

This has been discussed multiple times on community - In fact in the post just above yours. Make sure you search community for already discussed topics before duplicating them. 

Now to the solution:

1. First option - The grouping dimensions suggested by @Vegar  is usually my preference as it does not require additional work on NPrinting side https://community.qlik.com/t5/Qlik-NPrinting/Want-to-calculate-column-total-in-Nprinting-HTML-report.... I also like it because if have many expressions then you dont need to replicate them but...

2. Second option - Since total is just one extra line you can use NPrinting formulas in order to put them at the bottom of your table: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ReportsDevelopment/Formulas.htm

You would need to create as many totals formulas as many expressions you have in your table (1 formula for each measure)

cheers