topic Sort Order changes between Straight Table & Combo Chart in QlikView

Sort Order changes between Straight Table & Combo Chart

Thu, 09 Feb 2012 17:35:11 GMT

See small example attached. Notice I have the sort order on LineSalesAmount then Customer in the straight table. However when I use the fast change to combo chart the sort order completely changes. How do I make the sort order on the combo chart the same as the straight table. I need both chart types to be in the same sort order.

Sort Order changes between Straight Table & Combo Chart

pover — Thu, 09 Feb 2012 17:53:53 GMT

Changing your object to a combo chart, go to Properties->Sort and enable the Y-value Sort and select 'Descending'. If you change the table sort dynamically it won't change in the combo chart, but if you change the order of the table columns (eg. drag UnitsonOrder column so it appears before LineSalesAmount), you can get the combo chart to either do a descending sort of LineSalesAmount or UnitsonOrder.

Karl

Sort Order changes between Straight Table & Combo Chart

Wed, 15 Feb 2012 15:24:25 GMT

Hi Karl, Thanks but how do you sort on the Y value then on the dimension in a Line or Combo Chart. For example using the QVW attached above. If I had several customers with the same $ Amount in Column 1 how do I sort on the Y value (descending) then on the Customer dimension (ascending) in a Line or Combo Chart. I hope this is clear.

Melinda

Re: Sort Order changes between Straight Table & Combo Chart

Wed, 15 Feb 2012 17:35:02 GMT

Attached is an example of the sort order changing when I go from a straight table to either a Line or Combo Chart. As you can see the straight table is order based on the Perct_change (descending) and Customer column. However, when you switch to a line chart (use Fast Change button) the sort order is not in the same order as the straight table. How can I get the straight table and line chart to match sort order?

Re: Sort Order changes between Straight Table & Combo Chart

pover — Wed, 15 Feb 2012 18:09:47 GMT

The easiest way and if the user doesn't change the order in the table would be to sort by the expression and then by text. I've included an updated version of your file.

Karl

Re: Sort Order changes between Straight Table & Combo Chart

mdmukramali — Wed, 15 Feb 2012 20:32:59 GMT

Dear,

sort the Y-axis values in the Descending order. then sum(LineSalesAmount) will come in order same as order in straight table..

Re: Sort Order changes between Straight Table & Combo Chart

Thu, 16 Feb 2012 19:58:25 GMT

Thank you Karl, this is pretty much what I needed.