NPrinting - Create Table with Levels

[christiana]

Hi,

I'm trying to create an Excel report with NPrinting via Levels, so that I do not need to create many tables in Qlikview (the application is already too hugh).

So far I'm only coming up to this report:

Based on those settings

What do I need to do so that I get all rows of the Company and PLZ column filled (cf. screenshot below)?

Ideally with subtotals for the PLZ column?

Many thanks for your help!

[Daniel_Jenkins · Accepted solution]

Hi Christiana,

You can place the Company and PLZ tags on the rows. Also follow this tutorial: How to Create Excel Reports with Nested Levels & Subtotals

I have attached the sample project that I used for the above. Extract to C:\Temp\Community\032 or change the path in the NSQ as needed.

HTH - Daniel.

[christiana]

Hi Daniel,

many thanks for your answer. I have had a look into the tutorial but I couldn't make the abstraction in order to get where I wanted to get. But thanks to your example I could set it up.

Many, many thanks for your support!

Christiana