topic Re: Dimension wise Sub total in Nprinting html in Qlik NPrinting

Dimension wise Sub total in Nprinting html

Aditya_Chitale — Fri, 15 Nov 2024 22:23:52 GMT

Hello All,

I have a table as given below:

Team Lead	Project	Walkin	Booking
A	XYZ	10	5
A	ABC	20	6
A	PQR	30	7
B	LMN	40	8
B	UVW	50	9
C	DEF	60	10

I want to show subtotal grouped on basis of Team Lead.

Desired output:

Team Lead	Project	Walkin	Booking
A	XYZ	10	5
A	ABC	20	6
A	PQR	30	7
Total		60	18
B	LMN	40	8
B	UVW	50	9
Total		90	17
C	DEF	60	10
Total		60	10

Is there any way to achieve this using html in Nprinting ?

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

AshutoshBhumkar — Sat, 25 Dec 2021 09:26:16 GMT

Hello Aditya,

Can you just create a pivot table in Qlik sense and add that table an an image in HTML report.

This will work is the no. of rows are limited.

Re: Dimension wise Sub total in Nprinting html

Lech_Miszkiewicz — Sun, 26 Dec 2021 02:37:11 GMT

Hi @Aditya_Chitale

Absolutely.

Smart data modeling opens up a lot of possibilities. My approach is to create dedicated dimensions in script which would have "Total" line created during load script as one of dimension values.

those concepts are described here in general:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-HTML-Reports-with-Totals-and-Subtotals/td-p/1664570

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-I-can-show-SubTotals-in-NPrinting-Word-Report/td-p/1675337

detailed concept of subtotals in straight tables is described here by @Vegar (Thanks Vegar):

http://www.aqlik.se/2019/01/sub-totals-in-a-qlik-straight-table/

Once you have subtotals in straight table then it is up to your HTML skills to make it looking nice in NPrinting HTML report

cheers

Re: Dimension wise Sub total in Nprinting html

Aditya_Chitale — Sun, 26 Dec 2021 07:30:44 GMT

Hi Ashutosh,

I tried adding it as image but it limits the number of rows displayed.

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

Aditya_Chitale — Sun, 26 Dec 2021 14:17:50 GMT

hi @Lech_Miszkiewicz

I tried using your method, But since I have applied set analysis expression for showing YTD and MTD measure, in current scenerio, my measure is not returning correct values. So, will I need to calculate desired measure from script part itself ?

measure expression:

NUM(count(distinct{<[DATE]= {">=$(=vYTDStartDate_SO)<=$(=vEndDate_SO)"},SOURCE={'Walk-In'},[SM ROLE]={'Sourcing','Presales'},[SM STATUS]={'Active'},[SM EMP TYPE]={'NGL','Stack','MT','Presales'},[CM ROLE]=,[CM STATUS]=,[CM EMP TYPE]=>}[OPPORTUNITY ID]),'##.0')

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

Lech_Miszkiewicz — Mon, 27 Dec 2021 02:28:12 GMT

Hi, Hard to say without seeing all details behind your variables, data model etc..

Having set analysis in measure does not change anything in the method i have suggested so if applied correctly should work without issues.

cheers

Lech

Re: Dimension wise Sub total in Nprinting html

Aditya_Chitale — Mon, 27 Dec 2021 07:06:54 GMT

Hi @Lech_Miszkiewicz

Thanks ! It worked. Had to correct the subtotal flag field name. Just one last help needed, is it possible to highlight the subtotal row by any means in Nprinting using html ?

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

Lech_Miszkiewicz — Mon, 27 Dec 2021 10:00:12 GMT

absolutely. You need to be able to identify which row is a subtotal row by adding extra flags or even css syntax directly to Qlik table

Concept is described here:

cheers

Re: Dimension wise Sub total in Nprinting html

Aditya_Chitale — Thu, 30 Dec 2021 10:54:08 GMT

Hello @Lech_Miszkiewicz ,

Sorry for the late response, I tried the methods that you mentioned in provided links. But I am unable to highlight the subtotals row in html. I am able to do so in Qlik Sense. Kindly help in achieving the same in html too.

I have attached my html template.

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

Lech_Miszkiewicz — Thu, 30 Dec 2021 11:33:10 GMT

Hi.

With only html template i cannot do anything. It is first of all Qlik Sense app in which You need to create column in table which for each row of the data will return colour you want to have.
Then the value of colour needs to be put as inline style for cell in html table.

I may give you a working app and template sample tomorrow

Re: Dimension wise Sub total in Nprinting html

Aditya_Chitale — Fri, 31 Dec 2021 05:13:40 GMT

THANKS A TON !! @Lech_Miszkiewicz . It worked using the flag column method and unchecking html encode option from table column properties panel in Nprinting.

Regards,

Aditya

Re: Dimension wise Sub total in Nprinting html

Lech_Miszkiewicz — Fri, 31 Dec 2021 06:14:36 GMT

oh yeah - unchecking encode was in one of the topics i have given you link to 🙂

glad I could help - cheers.

by the way - I was about to start building example with step by step instructions but since you managed to figure it out i will pass for now.