topic data doesn't sort the right way in QlikView

data doesn't sort the right way

Wed, 09 Mar 2011 10:11:28 GMT

Hi,

I have a stacked bar chart in which i show an overview of paper and computer orders by sector. I use the following expression in my sort tab: =sum(paper_orders) + sum(computer_orders) it sorts almost right expect one value doesn't seem to follow the sort method...

red: paper_orders
blue: computer_orders

Somebody knows a possible answer to this? I already changed my expression a few times but always the same result...

data doesn't sort the right way

Miguel_Angel_Baeyens — Wed, 09 Mar 2011 10:30:42 GMT

Hello,

Assuming you have one dimension (Sector) and two expressions (first is paper orders and second is computer orders) in a stacked bar chart, you can use the Y-Value sort checkbox instead of the Expression. This will render the chart showing first that sector with highest value for the first expression (paper orders).

According to this, create a new expression:

Sum(paper_orders + computer_orders)

Uncheck the "Bar" tick in the expression (so there will be no new bar with this value), and check "Values on Data Points". Now promote this expression to the first place.

Now you get it.

Hope that helps.

data doesn't sort the right way

Wed, 09 Mar 2011 10:42:09 GMT

thx it works 🙂