Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 6, 2019: Click here for details and instructions.
lornafnb
Contributor III

creating excel line chart from QV model Table object

hi guys

I need to create this in an Excel template...

Capture.PNG

Here is a mock-up of some data that would be in this chart...

Please can you assist getting the look right?

thanks!

1 Reply
mkelemen
Contributor III

Re: creating excel line chart from QV model Table object

Hi,

probably the easiest way would be to change the QV table to have expression per each Callcentre.

Your export will then llok like this

MonthYearAcquisitionsVaultCash…SupersizeHuntersWiners…
<MonthYear_1><Acquisitions><Vault><Cash…><Supersize><Hunters>

<Winers…>

That way you can create the chart you want.

It's still a bit tricky - you need to create the chart using the Header and one line of real data. After you have created the chart just replace the data lines with placeholders from nprinting.

BR,

  Matus