nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series

cjgorrin — Thu, 03 Oct 2024 13:22:44 GMT

I am trying to implement a point chart in a Pixel Perfect report in nPrinting February 2024.

The chart has a qualitative X axis and a quantitative Y axis.

In my Qlik Sense app, I have a table like this one (which I imported into nPrinting):

WAREHOUSE	PRODUCT	Stock
W1	P2	1
W1	P3	2
W2	P1	3
W2	P2	4
W2	P3	1

I need a chart like this one:

So, I create a chart with the following characteristics:

Point chart.
Only auto-create series:
- View type: Point
- Qualitative argument scale
- Numerical value scale
- Point sort order ascending
- Sort points by argument
- Data member: the table
- Series: PRODUCT
- Argument: WAREHOUSE
- Value: Stock

Then, I expect the X-axis elements to be W1, W2, in this order. But I get W2, W1 instead. Why? Because the first series, P1, does not contain W1.

It seems the elements are put in the axis in the order they are discovered, series by series, also in order.

Is there any way to make the chart sort ALL the arguments (elements) together no matter the order of the series or whether they are present in the series at all?

Thanks a lot for your insights!

Re: nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series

cjgorrin — Fri, 04 Oct 2024 10:15:05 GMT

Maybe @Andrew_Kruger or @Gianluca_Perin can help? Thanks 🙂

Re: nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series

Frank_S — Fri, 04 Oct 2024 20:46:22 GMT

cc @Ruggero_Piccoli pxp sme

topic nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series in Qlik NPrinting

nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series

Re: nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series

Re: nPrinting - Qualitative axis element order in pixel-perfect chart with auto-create series