Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I'm looking to create a custom sort list in a pivot table. I want to enable the ability to define a sort order for a list of products so that when a user selects them, they will appear in an order based on priority. For example,
For the following products, I have numbered them in the order of priority.
1. Lemonade
2. Cranberry
3. Mango Punch
4. Limeade
5. Classic Margarita
But when I select these products, they do not appear in this order. From left to right, they currently appear in the following order
Classic Margarita
Cranberry
Lemonade
Limeade
Mango Punch
How do I enable it so that I can predetermine an order by which a product appears on a pivot chart. As the screen shot below illustrates, the order is not what I would like. It's currently displaying in the following order 5, 2, 1, 4, 3.
Take a look at this to see if it helps you.
http://qlikviewnotes.blogspot.com/2012/11/establishing-sort-order.html
-Rob
hi,
try load order for the field products in sort.
Niranjan M.
Take a look at this to see if it helps you.
http://qlikviewnotes.blogspot.com/2012/11/establishing-sort-order.html
-Rob