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: 
Lauri
Specialist
Specialist

Columns in table no longer available

I have an Excel report template in NPrinting that has worked well for a year. After adding more columns (some of which have a calculation condition) to a straight table in Qlik Sense, when I open the template, it says that none of the columns in the source table exist.

Is there a limit to the number of columns a table in Sense can have in order for NPrinting to be able to work with it? The table has 18 columns.

I have refreshed the Connection in NPrinting. I confirmed that the Connection is using the correct Sense app ID. I am able to add other table objects to the template, and the columns are available.

Thanks for any help.

1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

"black on white" in documentation - not supported. 

To answer your question in detail I will just say that as soon as you put any value in "show column if" property of the table, that table cannot be added as straight table object with individual columns - even if that value always return true. NPrinting checks for that condition and if it is present does not allow object to be used as table which is fair enough as it could lead to errors and issues (details below).

 

https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...

Some objects are not supported in Qlik NPrinting. These are:

  • Uncertified Qlik Sense extensions
  • Always one selected value for fields
  • Calculated conditions
  • Calculated dimensions

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.

View solution in original post

2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

"black on white" in documentation - not supported. 

To answer your question in detail I will just say that as soon as you put any value in "show column if" property of the table, that table cannot be added as straight table object with individual columns - even if that value always return true. NPrinting checks for that condition and if it is present does not allow object to be used as table which is fair enough as it could lead to errors and issues (details below).

 

https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Qlik-objects...

Some objects are not supported in Qlik NPrinting. These are:

  • Uncertified Qlik Sense extensions
  • Always one selected value for fields
  • Calculated conditions
  • Calculated dimensions

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.
Lauri
Specialist
Specialist
Author

Thank you, Lech. Hunted a bit in the documentation but didn't find that page.