Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

lornafnb
Not applicable

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
Not applicable

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

Community Browser