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: 
Morgoz
Contributor III
Contributor III

NPrinting. Show different columns depending on cycle dimension.

Hello,

I need to show the result of diferent Data Qualities in diferent Excel files (one per DQ).

So I have a table with all the Data Quality types and their headers (fields):

Morgoz_0-1627626537652.png

And a table containing all the data with all the possible fields in any DQ:

Morgoz_1-1627626692765.png

So, I was able to make a cycle in NPrinting to print a file per DQ, using the DQ Name as dimension for the cycle:

Morgoz_2-1627626906180.png

The problem now is that I don't know how to make NPrinting include just the fields of each DQ in its file. I mean, in the Excel template I have a table with all the posible fields in all DQs (based on DQ_CUSTOMER table), and what I need is that NPrinting uses only the corresponding fields of each DQ, based on the "DQ_VIEW_FIELDS" field that contains all the fields of each DQ.

In draft, something like this:

Table with headers (fields) per DQ:

Morgoz_11-1627628339676.png

Table with all fields of all DQs:

Morgoz_9-1627628158670.png

File for DQ 1

Morgoz_10-1627628195117.png

File For DQ 2

Morgoz_7-1627628004567.png

File For DQ 3

Morgoz_8-1627628047899.png

 

Any idea will be really appreciated.

Thank you.

Labels (2)
1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

Qlik NPrinting has not a native feature to conditionally hide or unhide columns. An idea could be to use the "Show column if" in Qlik Sense and add the table as single tag in the Excel template. Refer to https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp... for not supported configuration.

In PixelPerfect you could try to create many different native tables (yes, it will be a complex template) each with the different set of columns you want to obtain, then use formatting rules to unhide only the band (with related sub-bands) that me the condition. Use PixelPerfect if you want to have a PDF output. 

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

2 Replies
Ruggero_Piccoli
Support
Support

Hi,

Qlik NPrinting has not a native feature to conditionally hide or unhide columns. An idea could be to use the "Show column if" in Qlik Sense and add the table as single tag in the Excel template. Refer to https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp... for not supported configuration.

In PixelPerfect you could try to create many different native tables (yes, it will be a complex template) each with the different set of columns you want to obtain, then use formatting rules to unhide only the band (with related sub-bands) that me the condition. Use PixelPerfect if you want to have a PDF output. 

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
Morgoz
Contributor III
Contributor III
Author

Thank you Ruggero,

your solution seems to work for me.

Best regards.