topic Re: Dynamic Columns in NPrinting 17 Excel Report in Qlik NPrinting

Dynamic Columns in NPrinting 17 Excel Report

shubham_singh — Mon, 16 Jul 2018 18:00:45 GMT

Hi,

I have a requirement where I have to create a month wise customer wise YTD Sales where the month will be in column.

Its easy to do that in Qlik Sense Pivot table by putting month in column section however the pivot table does not show up in add table object section in NPrinting Designer.

Any ideas ?

I am using NPrinting April 2018 version connected to Qlik Sense Nov 2017.

Re: Dynamic Columns in NPrinting 17 Excel Report

Lech_Miszkiewicz — Mon, 16 Jul 2018 22:12:10 GMT

There are 2 options:

1. You go through the hassle and create a straight table with set analysis for each month

2. You can upgrade your NPrinting to version June 2018 - this supports pivot table in tables

regards

Lech

Re: Dynamic Columns in NPrinting 17 Excel Report

shubham_singh — Tue, 17 Jul 2018 05:34:35 GMT

1. I am ready to go through hassle but how do I remove columns that are beyond current month ?

2. Just the designer or engine as well ?

Thank you for your response.

Re: Dynamic Columns in NPrinting 17 Excel Report

Lech_Miszkiewicz — Tue, 17 Jul 2018 05:45:19 GMT

1. NPrinitng is building reports based on template. So you cannot simply remove a column and think that once new data comes this column will automatically appear.

The workaround is to create 12 columns and have conditional column labels which will convert to an empty string ('') if there is no data. In your Excel template you will need to have placeholder for all 12 months. Based on condition they will/will not produce value.

2. If you upgrade NPriniting (based on help.qlik.com) you need to have all 3 components (Server, Engine and Designer) to the same version.

Re: Dynamic Columns in NPrinting 17 Excel Report

Daniel_Jenkins — Wed, 18 Jul 2018 03:06:34 GMT

Hi Shubham,

Something to consider: if you use your straight table in your NPrinting report template as a single tag as opposed to one tag for each column/field, your report should render with whatever columns are currently in your source table as long as you either restart the NPrinting Engine service(s) or reload the Connection metadata before the Publish Task containing the report is run. You can trigger metadata reloads on a schedule.

HTH - Daniel.

Re: Dynamic Columns in NPrinting 17 Excel Report

shubham_singh — Wed, 18 Jul 2018 05:38:33 GMT

Yeah but how am I going to make the source dynamic. I going to have to modify table in Qlik Sense every month. That does not automate the process.

Re: Dynamic Columns in NPrinting 17 Excel Report

Lech_Miszkiewicz — Wed, 18 Jul 2018 05:51:56 GMT

What Daniel meant is that you can have those conditions in Qlik Sense. Since June version you can hide& show columns in Qlik Sense table based on conditions....

Then you can use a tag of a full table in NPrinting..

cheers

Lech

Re: Dynamic Columns in NPrinting 17 Excel Report

pradosh_thakur — Thu, 19 Jul 2018 06:46:20 GMT

Hi lech_miszkiewicz,

I am now on April 2018 version. When you say it supports pivot table does it mean the merged cells will be shown as it is and not be duplicated ? It was not really clear from the documentation .

regards

Pradosh

Re: Dynamic Columns in NPrinting 17 Excel Report

Lech_Miszkiewicz — Fri, 20 Jul 2018 00:29:06 GMT

I am not sure from the memory - will have to test it and get back to you.

Cheers

Lech