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: 
Not applicable

Nprinting Table/Chart import problem

Why is it that when I 'add object' for a chart in a Nprint report template that some charts do not have the drop down menu to display the field nodes that make up the chart or table?

Is this a problem with the creation of the chart in QV?

Thanks,

Kyle

4 Replies
Not applicable
Author

Those charts are probably pivot tables in the QVW.

If you want to be able to select specific fields from those charts, you'll have to convert them to straight tables (or clone them and convert the clones).

Best

Aran

Frank_S
Support
Support

It's not exactly clear what you mean by 'drop down' menu.

In any case, if you add a pivotal table chart or other non straight table items to the template editor field list on the top left of the template editor, the individual field values in the pivot or other non-straight table charts will not be available to drag and drop to the template editor.

In order to expose the individual fields of an QV Chart Object accessed from NPrinting (anything that is not a straight table), you must first clone and then convert the object to a straight table in Qlikview and save the QVW.

You then need to refresh the object cache and then search for the new QVW object number.

This new object can now be expanded to show the individual fields.

What can you do with a QV straight table in NPrinting? See a couple article below:

How to Create a Pivot Table from Excel Table Columns

https://community.qlikview.com/docs/DOC-8420

How to Add Levels in Excel Reports

https://community.qlikview.com/docs/DOC-8406

Developer Knowledge base

http://community.vizubi.com/knowledgebase

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

I am also having troubles with some of my bar charts. Is there a fix for those as well?

Some of my bar charts have calculated conditions on them .. could this be part of the issue? If so what is a way around this so that I do not have to remove the calculated conditions?

Not applicable
Author

Kyle

I am guessing when you say drop down you are referring to the '+' sign on the left protion of the template?  As Frank said, you can only expand a table to see all of the columns if it is a straight table with QlikView - pivot tables will show in the Table portion of the template, but you cannot expand the table to see the columns.

Regarding bar charts, those typically have to be dimension fields but if you could attach a copy or a test copy of an application containg a chart with the issue I would be more than happy to take a look at it further