topic Totals for Table in HTML in Qlik NPrinting

Totals for Table in HTML

sogloqlik — Mon, 15 Aug 2022 07:15:55 GMT

Hi.

I have a report in HTML with table which has 4 columns in percentage format. I need to add Totals for each of the column. How can I achieve that? I tried to use <tfoot> with formulas but Is losses the Percentage format and shows decimal.

Regards,

Motty

Re: Totals for Table in HTML

ajaykakkar93 — Mon, 15 Aug 2022 09:33:40 GMT

Hi,
use Num(...,'format')
to format your total in html it will work

Re: Totals for Table in HTML

sogloqlik — Mon, 15 Aug 2022 10:18:53 GMT

Hi Ajay Kakkar

Where to add it? I tried in the formula but it doesn't work.

Re: Totals for Table in HTML

andregas — Tue, 16 Aug 2022 16:24:59 GMT

Hi @sogloqlik ,

You could try this:

text(num(<formula>, 'format'))

Re: Totals for Table in HTML

sogloqlik — Wed, 17 Aug 2022 11:08:58 GMT

My mistake.

Forgot small but very important thing: to put the format between '' 🤔🤕

Thank you both