Нow to add 2 dimension to the chart in NPrinting?

[segador_]

NPrinting 17.5

Pixel perfect report.

I have a table in QlikSense with two dimensions and one measure.

Sample:

Dimension1, Dimension2, Measure1

2015, 1, 100

2016, 1, 150

2017, 1, 165

2018, 1, 140

2015, 2, 100

2016, 2, 155

2017, 2, 160

2018, 2, 135

2015, 3, 90

2016, 3, 150

2017, 3, 155

2018, 3, 120

I need to build line chart with one line by each values of Dimension1. Dimension1 has a variable count of values and i can't add discrete count of series in chart. I try to use "Auto-created series", but it's not work correctly.

After these settings the chart built is empty.

[Lech_Miszkiewicz · Accepted solution]

Hi

Answering your HEADLINE question: it is basicly impossible. Multidimensional charts are not supported in PixelPerfect. I have raised feature request with rpc‌ regarding similar fuctionality.

If your requirement is to have dedicated line for each secondary dimension value (1,2,3) then your workaround is  by using set analysisin your measure and creating multiple series in your chart.

see similar case here:

Re: NPrinting Chart by Year

see more regarding this here (it covers basicly the same scenario):

PixelPerfect Stacked Lines Chart

and a video how to create charts in Pixel Perfect

Video Link : 3032

I think this will give you a full picture what is possible

cheers

Lech

---------------------------------------------

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.