topic Re: Nprint Pivot table formatting issue in Qlik NPrinting

Nprint Pivot table formatting issue

ronaldwang — Tue, 20 Mar 2018 02:33:29 GMT

I have created a pivot table in QVW and then using Nprint to export the table (by keeping source format). but the format is not the same as shown in qvw. the main issue is that in the qvw i have made the grid line disappeared but in the export file, the grid line is shown.

Re: Nprint Pivot table formatting issue

Chanty4u — Tue, 20 Mar 2018 06:09:27 GMT

did you uncheck the keep source format option for that table or not?

Re: Nprint Pivot table formatting issue

ronaldwang — Tue, 20 Mar 2018 06:25:59 GMT

no, I use keep source format as I want to keep the format I have done on qvw

Re: Nprint Pivot table formatting issue

Chanty4u — Tue, 20 Mar 2018 06:31:49 GMT

try to uncheck and do preview once .

Re: Nprint Pivot table formatting issue

ronaldwang — Tue, 20 Mar 2018 06:43:20 GMT

unchecked will have no format at all which is not what I want

Re: Nprint Pivot table formatting issue

Chanty4u — Tue, 20 Mar 2018 06:46:07 GMT

can us hare some screen shots which is currently there [before uncheck ] and which is your expectation?

Re: Nprint Pivot table formatting issue

ronaldwang — Tue, 20 Mar 2018 07:09:18 GMT

In the attached app, for pivot table "Data". there is no grid line. but when exporting to excel, the grid line will appear.

Re: Nprint Pivot table formatting issue

Lech_Miszkiewicz — Tue, 20 Mar 2018 22:06:29 GMT

Hi Ronald,

technicaly grid line is there (it is just transparent as per colour settings in "Light" style). Excel does not support alpha channel for transparencies therefore you see grid and all transparencies are removed from color settings.

There are 2 things you can try:

1. untick the boxes to disable completely grid lines (as per screenshot)

2. turn on "grid view" in QlikView and use "custom format cell" and make the grid colour white ( rather than transparent) it will be there but it will be white then therefore not visible.

cheers

Lech

Re: Nprint Pivot table formatting issue

ronaldwang — Tue, 20 Mar 2018 23:36:24 GMT

Thanks Lech as always.

It makes a lot of sense now. I have tried the 2 things you mentioned. the first will make vertical grid line disappear but not the horizontal grid line

and for the 2 thing to do , I have made the grid line white as below, but when exporting to excel, the horizontal grid line still appears. did I miss anything here?

Re: Nprint Pivot table formatting issue

Lech_Miszkiewicz — Tue, 20 Mar 2018 23:55:09 GMT

I am not sure,

I think you have done everything right. I might need to test it on my environment little bit later. Right now i do not have access to QlikView and NPrinitng

will let you know if i find a right solution.

regards

Lech

Re: Nprint Pivot table formatting issue

ronaldwang — Wed, 21 Mar 2018 00:32:35 GMT

Thanks Lech

Re: Nprint Pivot table formatting issue

Lech_Miszkiewicz — Thu, 22 Mar 2018 08:32:54 GMT

Hi Ronald,

I have tested it.

Looks like this is QlikView 12.XX issue. I actually think it is a bug which if you like you might want to raise with Qlik.

I tested it with QlikView 11.2 SR 15 and I managed to hid horizotal boundries for expression cells as well: like this:

sorry i could not help more

cheers

Lech

QV 11 results:

QV 12 results:

Re: Nprint Pivot table formatting issue

ronaldwang — Thu, 22 Mar 2018 23:05:14 GMT

Thanks Lech, that is good enough.

Re: Nprint Pivot table formatting issue

Lech_Miszkiewicz — Wed, 16 May 2018 22:14:51 GMT

Hi Ronald

are you still interested in this topic? I might have discovered something quite interesting. It will require more testing that's why i am asking if you still need to get rid of grid lines.

regards

Lech

Re: Nprint Pivot table formatting issue

ronaldwang — Thu, 17 May 2018 01:46:32 GMT

Hi Lech,

Thanks for keeping this in mind, I have managed to used straight table to get rid of the grid lines. but would be interested to see your idea on how to get rid of grid lines and I can do the testing for you. but maybe in another week's time as I am not in office for this week. thanks

Re: Nprint Pivot table formatting issue

Lech_Miszkiewicz — Thu, 17 May 2018 02:06:32 GMT

Yep - i found a solution!!!

It must be something more than what we can access via "Custom format cell". So what i noticed is that if you go to your Pivot Table--> Properties --> Styles and change your style to "Clean" and after that alter your Pivot table headers with "custom format cell" your output will have no gridlines at all.

interesting - but it works!

If it works for you than if possible please change CORRECT answer to this one.

cheers

Lech

below results

Re: Nprint Pivot table formatting issue

ronaldwang — Thu, 24 May 2018 03:24:46 GMT

thanks for your effort and it works, amazing!