- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe @Andrew_Kruger or @Gianluca_Perin can help? Thanks 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
cc @Ruggero_Piccoli pxp sme