Excel report calculate a cell from a table

ra162512 — Sat, 16 Nov 2024 02:54:30 GMT

Hello Everyone,

I'm currently using Nprinting version November 2018.

I have created a table on an Excel Nprinting report.

I would like to create some rows that are calculated from the previous table. However in Nprinting the table is only represented by a tab. I don't see how to do it.

Let's say for example that I have the following table:

Which generates the following table

, I would like to generate (with the Excel Npriting) the last cell, 26 which corresponds to the sum of my column value.

Re: Excel report calculate a cell from a table

Lech_Miszkiewicz — Fri, 26 Jul 2019 06:58:20 GMT

there are couple ways of how you can do this:

http://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ExcelReports/Totals-Feet-Columns-Tables.htm
http://help.qlik.com/en-US/video/HjIK7cC9HJk

See on the video how subtotals are created.

Also in the video there is a reange used insted of table...

topic Re: Excel report calculate a cell from a table in Qlik NPrinting

Excel report calculate a cell from a table

Re: Excel report calculate a cell from a table