topic Re: formatting a pivot table in Qlik NPrinting

formatting a pivot table

ali_hijazi — Tue, 19 May 2020 07:47:13 GMT

Hello I'm new to NPrinting
I got a P&L pivot table in qlik sense dashboard but as you know we cannot deeply format the output in Qlik Sense
the Pivot Table looks like this:

however the expected look is like this:

is there a way by which I can see exactly the pivot table in Qlik Sense in NPrinting and I do the formatting there?
the output is set to be as Excel

kindly advise

Re: formatting a pivot table

Lech_Miszkiewicz — Tue, 19 May 2020 08:20:00 GMT

This is possible however it requires planning (typical to P&L) where you need to have few extra columns indicating the format of the row.

To be honest for P&L in Qlik Sense I also use straight table with proper mapping and indenting using CHR160

as for NPrinting

My approach is normally to use straight table in QlikView /Qlik Sense with appropriate groupings and formats passed to hidden excel columns and use of excel conditional formatting to apply formats.

Re: formatting a pivot table

ali_hijazi — Thu, 21 May 2020 06:27:53 GMT

is there a way to show me how ? cause I'm new to nprinting

Re: formatting a pivot table

Lech_Miszkiewicz — Thu, 21 May 2020 08:47:40 GMT

forget NPrinting for a moment..

1. make sure you prepare your data first in Qlik Sense

Create your PnL using Straight table in Qlik Sense
Create column in this table which will indicate all possible formats like:
- grand total
- subtotal
- number format 1
- number format 2 etc..
- colour 1
- colour 2 etc..
- font A
- font B etc... this column will be later used in EXCEL conditional formatting

So up until now there is nothing related to NPrinting really, right?

Once you have this done you need to bring in this table to NPrinting and create a single table in excel. Bring also that additional column which clearly indicates formatting.

Then use conditional Excel formatting based on the value in that additional column

https://youtu.be/uVTk0n277lw

The only thing you do in NPrinting is bringing data and creating formatting rules.

This is not easy to explain in single post on community. I may spend a day trying to explain all steps during NPrinting training session, but the fact is that most planning and development is done in Qlik Sense...