Sort order issues

vhayward — Thu, 03 Feb 2011 14:27:58 GMT

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

Sort order issues

vhayward — Fri, 04 Feb 2011 09:31:23 GMT

Anyone?

Sort order issues

prieper — Fri, 04 Feb 2011 15:08:42 GMT

Can you please post an example?

++Peter

topic Sort order issues in QlikView

Sort order issues

Sort order issues

Sort order issues