Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
shubham_singh
Partner - Creator II
Partner - Creator II

Dynamic Columns in NPrinting 17 Excel Report

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.

8 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
shubham_singh
Partner - Creator II
Partner - Creator II
Author

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.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Daniel_Jenkins
Specialist III
Specialist III

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.

shubham_singh
Partner - Creator II
Partner - Creator II
Author

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.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
pradosh_thakur
Master II
Master II

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

Learning never stops.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.