Create a custom sort order of items on a Pivot Chart

[#1]

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.

[#2]

hi,

try  load order for the field products in sort.

Niranjan M.

[rwunderlich · Accepted solution]

Take a look at this to see if it helps you.

http://qlikviewnotes.blogspot.com/2012/11/establishing-sort-order.html

-Rob