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

[cjgorrin]

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!

[cjgorrin]

Maybe @Andrew_Kruger or @Gianluca_Perin can help? Thanks 🙂

[Frank_S]

cc @Ruggero_Piccoli pxp sme