topic Reverse Sorting order in the bar chart (stacked) in QlikView

Reverse Sorting order in the bar chart (stacked)

Tue, 22 Jan 2013 08:48:21 GMT

Hi,

we are having a Age band with the below values. If we add this Age Band in a list box, The sort order will display correctly.

Age Band
0 to 10,
11 to 20,
21 to 100

We are adding this AgeBand in a Bar Chart (stacked), which is having two dimension. After this the values is coming reverse (i.e 21 to 100,11 to 20,0 to 10). To correct this we have to set the sort order in reverse (i.e Z-> A) and it displaying correctly.

In our QVW business needs the option for fast change of line graph, as the sort order is set for 'Z-A', the sort is reversing in the line chart (i.e 21 to 100,11 to 20,0 to 10).

Note : If the bar chart is not stacked it will display the sort order correctly.

I have attached a sample QVW. Please could you have a look and advise.

Please let me know if any more information is required.

Thanks,
sijo

Re: Reverse Sorting order in the bar chart (stacked)

billbois — Mon, 24 Feb 2014 22:40:22 GMT

I wish I had a solution for you. I'm having exactly the same problem. Have you been able to figure out a solution since posting this?

Thanks,

Bill

Re: Reverse Sorting order in the bar chart (stacked)

Chris_Rice — Mon, 02 Jun 2014 15:42:49 GMT

This unfortunately is "As Designed". The only work around so far is to create two different charts so you can use the "Reverse" function on the legend of one to make the legends the same. I would encourage you to open an "Idea" to get this functionality in the future.