Solved: using a excel pie chart with nprinting - Qlik Community

ogster1974 · ‎2017-06-28

Hi Guys

Im using NP17.3 with Qlik Sense.

I had pie charts coming through from Sense under levels nicely but one of the feedback from the client ws they didnt want the pie chart to flip from % to value when the value was 100%. Part of Sense being helpful but in reporting they want consitency or format.

So I've looked into replacing the image with a excel generated chart which ive done,

Result

All nice a pretty but when I add the other levels in around it the pie chart doesn't generate as Id expect.

2 Issues I see. 1 the data source jumps a row. 2 it only applies to the first cut of the level. Result in screenshot in below post. What am I doing wrong when it comes to implementing the chart in a multi level sheet. It only seeems to work with one level and thats the table.

Regards

Andy

Ruggero_Piccoli · ‎2017-06-28

Dear Andy,

Unfortunately at the moment you cannot insert a native Excel chart nested into a level due to the problems you reported. Instead you can use the Page node, so create a different Excel worksheet for each value of the field you inserted into the level.

If you want an output in PDF you could also evaluate to develop a PiaxelPerfect template.

I hope this helps.

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

ogster1974 · ‎2017-06-28

the result not the postion of the selected data source.

Its using this source to generate the same pie chart at each level.

Ruggero_Piccoli · ‎2017-06-28

Dear Andy,

Unfortunately at the moment you cannot insert a native Excel chart nested into a level due to the problems you reported. Instead you can use the Page node, so create a different Excel worksheet for each value of the field you inserted into the level.

If you want an output in PDF you could also evaluate to develop a PiaxelPerfect template.

I hope this helps.

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

ogster1974 · ‎2017-06-28

Thanks for your reply.

Is this an issue in 16 aswell? or just a feature not suppported in 17 yet.

Ruggero_Piccoli · ‎2017-06-28

Before answering you I tested both 17.4 and 16.6 and both do not support native Excel charts inside levels.

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

ogster1974 · ‎2017-06-28

Thankyou for the comprehensive response even if its not what I wanted to here

Regards

Andy

Lech_Miszkiewicz · ‎2017-06-29

Hi Ruggero

I guess this relates also to:

pivot tables/charts
tables (Excel Tables)

doesn't it?

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

Ruggero_Piccoli · ‎2017-06-30

Hi Lech,

I tested all to write a complete answer:

- Exel pivot tables and pivot charts don't work inside a level

- Excel tables work inside a Level

Cheers,

Ruggero

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 with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.