Pivot Table editing and copying of charts

[Anonymous]

Hello,

I have a large data set that I use to create about 30 different pivot tables.  Each pivot table is then used to create a chart.  15 of the charts use the Cost and 15 use the Sale Price.  I have the Cost charts completed, and now what to copy those 15 charts, change the source of data  to reference the Sale Price pivot tables.  I am unable to make that change.  If I change the option in PivotTable Options, the change is done for both charts..  Is there a way to copy the one set of charts, and not have them linked?

Thank you.

Jennifer

[vvira1316]

Hi,

Is there a reason for you to use each of those pivot table as a source for these charts. Why not have a single source to create charts out of those. Without you providing sample of data, charts, app and script will be difficult to advise.

Ideally your data model either in Qlik or from wherever you are sourcing from should support creating various charts. If the source is not suited then it should be modeled on Qlik side.

Please share sample data/app, etc. to help you further.

BR,

Vijay

[Anonymous]

Thank you for your response.  The issue I am having is not with the data source, it is with the chart.  When I update the chart data range on the copied chart, the range is also updated for the original chart. I am asking if there is a way to make a copy of a pivot chart without the copy linking to the original?

Thank you.

Jennifer

[vvira1316]

‌if you pasred them as linked object then unlink them by using right click menu on object

other option maybe using alternate state for them. Field Tiggers

[Ruggero_Piccoli]

Hi,

Please specify the version of Qlik NPrinting you are using. Please give us some other details like a screenshot of the template, a screenshot of the generated report etc.

If you create a chart of the second group manually instead of copy and modifying it, will it work or do you have the same problem?

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.

[Anonymous]

If you unlink after copying the table using the left mouse button in the new tables and choosing the unlink option.