topic Re: Nprinting Straight Table no Columns? in Qlik NPrinting

Nprinting Straight Table no Columns?

cbaqir — Wed, 20 Sep 2017 20:09:04 GMT

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

Re: Nprinting Straight Table no Columns?

Wed, 20 Sep 2017 22:12:49 GMT

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

Re: Nprinting Straight Table no Columns?

Ruggero_Piccoli — Thu, 21 Sep 2017 10:57:36 GMT

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.

Re: Nprinting Straight Table no Columns?

cbaqir — Thu, 21 Sep 2017 15:07:17 GMT

They are both straight tables.

Re: Nprinting Straight Table no Columns?

Ruggero_Piccoli — Thu, 21 Sep 2017 15:27:04 GMT

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

---------------------------------------------

Re: Nprinting Straight Table no Columns?

Onyi_Nwabia-Robbins — Tue, 06 Aug 2019 13:12:36 GMT

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