NPrinting Levels

[m_perreault]

Hi All,

I have the below table in Qlik Sense

Company	Individual ID	Pair ID	Date	Amount
ABC Company	1A	111	9/8/2018	500
ABC Company	1B	111	9/8/2018	500
ABC Company	2A	222	9/8/2018	750
ABC Company	2B	222	9/8/2018	750
CC Company	3A	333	9/1/2018	200
CC Company	3B	333	9/1/2018	200
BB Company	4A	444	8/31/2018	350
BB Company	4B	444	8/31/2018	350

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

Shipper	Individual ID	Pair ID	Date	Amount
ABC Company	1A	111	9/8/2018	500
ABC Company	1B	111	9/8/2018	500
ABC Company	2A	222	9/8/2018	750
ABC Company	2B	222	9/8/2018	750

Shipper	Individual ID	Pair ID	Date	Amount
CC Company	3A	333	9/1/2018	200
CC Company	3B	333	9/1/2018	200

Shipper	Individual ID	Pair ID	Date	Amount
BB Company	3A	444	8/31/2018	350
BB Company	4B	444	8/31/2018	350

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

Thanks!

Mark

[Daniel_Jenkins · Accepted solution]

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.