Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator III

NPrinting Levels

Hi All,

I have the below table in Qlik Sense

CompanyIndividual IDPair IDDateAmount
ABC Company1A1119/8/2018500
ABC Company1B1119/8/2018500
ABC Company2A2229/8/2018750
ABC Company2B2229/8/2018750
CC Company3A3339/1/2018200
CC Company3B3339/1/2018200
BB Company4A4448/31/2018350
BB Company4B4448/31/2018350

I would like to create an Excel NPrinting Report from the above table in which tables are broken up by Shipper and Date meaning I would get the below tables in the NPrinting Report

ShipperIndividual IDPair IDDateAmount
ABC Company1A1119/8/2018500
ABC Company1B1119/8/2018500
ABC Company2A2229/8/2018750
ABC Company2B2229/8/2018750

ShipperIndividual IDPair IDDateAmount
CC Company3A3339/1/2018200
CC Company3B3339/1/2018200

ShipperIndividual IDPair IDDateAmount
BB Company3A4448/31/2018350
BB Company4B4448/31/2018350

Does anyone know how I could use levels to accomplish this?

Thanks!

Mark

1 Solution

Accepted Solutions
Daniel_Jenkins
Specialist III
Specialist III

Hi Mark,

Use the Shipper field as a level.

This video shows how to create 2 levels - you will need just one:

https://help.qlik.com/en-US/video/HjIK7cC9HJk

HTH - Daniel.

View solution in original post

1 Reply
Daniel_Jenkins
Specialist III
Specialist III

Hi Mark,

Use the Shipper field as a level.

This video shows how to create 2 levels - you will need just one:

https://help.qlik.com/en-US/video/HjIK7cC9HJk

HTH - Daniel.