Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
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