Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
cjgorrin
Contributor III

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

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:

cjgorrin_3-1727961537416.png

 

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!

Labels (2)
2 Replies
cjgorrin
Contributor III
Author

Maybe @Andrew_Kruger or @Gianluca_Perin can help? Thanks 🙂

Frank_S
Support

cc @Ruggero_Piccoli pxp sme

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!