Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
vhayward
Partner - Contributor III
Partner - Contributor III

Sort order issues

Hello all,

I have different sort order issues. Let me explain a few:

1) Product Groups on the X and Wholesaler Groups on the Y.

At first the the sort orders are working well with the sort option:
Wholesaler Group -> Expression =min[Wholesaler Sortorder]
Product Group-> Expression =min[ProductSortorder]

But when you drill down on a wholesaler group the product sort order begins the change, which isn't what I expected.
The same goes when I start drill down on a product group the sort order from the wholesalers starting to change.

How can I solve this?

2) I have a simple list box with product types. The product types do have a corresponding sort value. For intance: Cola - 1, Sinas - 2, Beer - 3, etc.

Yet the box is sorting the product types based on the sort order I have presented.
I have used Sort -> Expression = min([Product Type Sortorder])

Yet it does something completely random as it seems for me.

How can I solve this issue as well?

Thanx in advance, community!

Sincerely Yours,
Vincent Hayward

2 Replies
vhayward
Partner - Contributor III
Partner - Contributor III
Author

Anyone?

prieper
Master II
Master II

Can you please post an example?

++Peter