Show Totals in NPrinting (per column)

[Morgoz]

Hello,

I need to show totals per column of a table in NPrinting. I know there is a post related to this issue, but as far as i could understand it shows how to add totals per row, not per column.

Here is my table in Qlik Sense:

In NPrinting i have just added that table to the sheet, but there are no total's row at the top:

Thank you.

[Frank_S · Accepted solution]

@Morgoz 
Check out the video in this link which describes how to use NPrinting to generate totals using tabular data.

• https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ExcelReports/Excel-Reports-Nest...

If you don't mind using images, you can get the source totals in your output by using the source table as an image.

Hope this helps to guide you in the right direction...

[Lech_Miszkiewicz]

So I am a little bit confused as I am not sure of your requirement. 

If by saying "totals per column" you mean the second row (right below the headers with total value for every single column in the table) you can:

• If the report template is XLS utilize excel functionality to apply totals
• Create in your Qlik Sense data model grouping dimension with the TOTAL label (see this example https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-show-total-in-Nprinting-V17-reports/...)

[Morgoz]

Thank you both, Frank and Lech,

both anwers helped me to compose a solution.
Now I have a new problem... I don't know if it is necessary to open a new post... the thing is that I have set a format for a column but it is not replicating to all rows automatically.

Here is the configuration:

and here is the result:

I want the rows to be highlighted in light blue, but as you can see in the result, it is not being applied.

Thank you.

[Ruggero_Piccoli]

Hi,

Yes please create a single post for every question with an expletive subject. This will help other people to understand if the question help them.

You can use the Excel formatting features by using conditional formats or by inserting a native Excel table. Also a complete screenshot of the template will help.

Best Regards,

Ruggero