Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Nprinting Straight Table no Columns?

untitled.png

Why would CH311 show the fields in the straight table but CH300 would not?

1 Solution

Accepted Solutions
Ruggero_Piccoli
Employee
Employee

So:

- reload the metadata for the related connection

- do a right click over the object and update it

I'm suggesting these actions because I suppose CH300 was changed from pivot to straight after last update.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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

5 Replies
Not applicable

Basically, You can only expand a table to see all of the columns - if it is the straight table in QlikView Dashboard BUT Pivot tables will only show in the Table portion of the template, but you cannot expand the table to see the columns. This could be one of the reason, sorry if it's not the same.

Thanks

Ruggero_Piccoli
Employee
Employee

Because CH300 is a pivot table and not a straight table.

You could:

- change the type of CH300 to straight

- clone the CH300 and change the type of the clone to straight. If necessary you can hide the clone because NPrinting supports hide tables if they are saved on visible sheets.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.
cbaqir
Specialist II
Specialist II
Author

They are both straight tables.

Ruggero_Piccoli
Employee
Employee

So:

- reload the metadata for the related connection

- do a right click over the object and update it

I'm suggesting these actions because I suppose CH300 was changed from pivot to straight after last update.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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

Onyi_Nwabia-Robbins
Contributor III
Contributor III

I was having the same problem but this time with a Qlik Sense app connection to Nprinting app.

Didn't matter how many times I reloaded the metadata, once I converted a pivot table to a straight table it seemed to remember it as that. 

When drag the table into my template and preview it sees it as a straight table

BUT there was no option to expand the columns.

I had recreate the table from scratch and then reload metadata.

Lesson, don't convert pivot table to straight table in qlik sense app for nprinting, recreate table instead and bring that into template