topic Re: using a excel pie chart with nprinting in Qlik NPrinting

using a excel pie chart with nprinting

ogster1974 — Wed, 28 Jun 2017 09:56:07 GMT

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

Re: using a excel pie chart with nprinting

ogster1974 — Wed, 28 Jun 2017 09:58:09 GMT

the result not the postion of the selected data source.

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

Re: using a excel pie chart with nprinting

Ruggero_Piccoli — Wed, 28 Jun 2017 12:53:08 GMT

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.

Re: using a excel pie chart with nprinting

ogster1974 — Wed, 28 Jun 2017 12:55:56 GMT

Thanks for your reply.

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

Re: using a excel pie chart with nprinting

Ruggero_Piccoli — Wed, 28 Jun 2017 13:30:37 GMT

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

Re: using a excel pie chart with nprinting

ogster1974 — Wed, 28 Jun 2017 13:37:36 GMT

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

Regards

Andy

Re: using a excel pie chart with nprinting

Lech_Miszkiewicz — Fri, 30 Jun 2017 01:46:44 GMT

Hi Ruggero

I guess this relates also to:

pivot tables/charts
tables (Excel Tables)

doesn't it?

cheers

Lech

Re: using a excel pie chart with nprinting

Ruggero_Piccoli — Fri, 30 Jun 2017 13:12:56 GMT

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