topic Re: Nprinting Table/Chart import problem in Qlik NPrinting

Nprinting Table/Chart import problem

Tue, 28 Jul 2015 20:59:23 GMT

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

Re: Nprinting Table/Chart import problem

Tue, 28 Jul 2015 21:04:15 GMT

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

Re: Nprinting Table/Chart import problem

Frank_S — Tue, 28 Jul 2015 21:16:11 GMT

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

Re: Nprinting Table/Chart import problem

Wed, 29 Jul 2015 13:11:45 GMT

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?

Re: Nprinting Table/Chart import problem

Mon, 03 Aug 2015 16:04:47 GMT

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