topic NPrinting Chart by Year in Qlik NPrinting

NPrinting Chart by Year

Anonymous — Mon, 25 Sep 2017 09:27:52 GMT

Hi,

i would like to create a line stacked chart by Nprinting having two dimension as: month(data_field) and year(data_field)

As expression: sum(Sales)

I can display only one line and i would differents lines for each year

The aspetted result would be similar as this (image attached)

Any suggestios?

thank you

Re: NPrinting Chart by Year

mkelemen — Mon, 25 Sep 2017 10:47:13 GMT

Hi Federico,

if you are exporting to Excel you can use the Pivot chart functionality to get this chart.

BR,

Matus

Re: NPrinting Chart by Year

Anonymous — Mon, 25 Sep 2017 10:50:20 GMT

Yes but i must to insert it in a Pixel Report template. It's the same?

Re: NPrinting Chart by Year

mkelemen — Mon, 25 Sep 2017 11:23:22 GMT

Sorry, I am not using pixelperfect but I think it is completelly different.

BR,

Matus

Re: NPrinting Chart by Year

Lech_Miszkiewicz — Mon, 25 Sep 2017 11:27:03 GMT

You cannot add multiple dimension in PixelPerfect Chart.

As an alternative you can build (using for example set analysis) dedicated measures for each year - I know that it is not ideal solution, but currently there is not other option.

Then you can add one dimension (month) and multiple line series (each representing differnet year)

hope this helps

regards

Lech

Re: NPrinting Chart by Year

Ruggero_Piccoli — Mon, 25 Sep 2017 12:56:54 GMT

In PixelPerfect you can create a stacked lines chart.

I'm wrinting the instructions.

Re: NPrinting Chart by Year

Ruggero_Piccoli — Mon, 25 Sep 2017 13:32:13 GMT

I wrote a step by steo tutorial about how to create a line stacked chart in PixelPerfect PixelPerfect Stacked Lines Chart

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.