topic Bar chart sort by data difference in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308447#M1187109 <HTML><HEAD></HEAD><BODY><P>I need to sort by data difference. The objective in this chart is to maintain an equal balance of inventory by item type between my two warehouses.</P><P></P><P>The first item in the chart should therefore be the item that is the least balanced across my warehouses.</P></BODY></HTML> Mon, 29 Aug 2011 22:13:06 GMT 2011-08-29T22:13:06Z Bar chart sort by data difference https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308447#M1187109 <HTML><HEAD></HEAD><BODY><P>I need to sort by data difference. The objective in this chart is to maintain an equal balance of inventory by item type between my two warehouses.</P><P></P><P>The first item in the chart should therefore be the item that is the least balanced across my warehouses.</P></BODY></HTML> Mon, 29 Aug 2011 22:13:06 GMT https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308447#M1187109 2011-08-29T22:13:06Z Bar chart sort by data difference https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308448#M1187110 <HTML><HEAD></HEAD><BODY><P>I would prefer to do it within the control and not inthe script. This would enable the data to be resorted depending on the user’sfiltering.</P></BODY></HTML> Mon, 29 Aug 2011 22:17:58 GMT https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308448#M1187110 2011-08-29T22:17:58Z Re: Bar chart sort by data difference https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308449#M1187111 <HTML><HEAD></HEAD><BODY><P>Probably sort by expression, maybe something along these lines sorted descending?</P><P></P><P style="padding-left: 30px;"><SPAN style="font-family: courier new,courier;">fabs(sum({&lt;Warehouse={'one'}&gt;} Inventory)</SPAN><BR /><SPAN style="font-family: courier new,courier;">&nbsp;&nbsp;&nbsp; -sum({&lt;Warehouse={'two'}&gt;} Inventory))</SPAN></P></BODY></HTML> Mon, 29 Aug 2011 22:28:28 GMT https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308449#M1187111 johnw 2011-08-29T22:28:28Z Re: Bar chart sort by data difference https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308450#M1187112 <HTML><HEAD></HEAD><BODY><P> Thanks allot for your info. its working fine</P></BODY></HTML> Tue, 30 Aug 2011 22:32:40 GMT https://community.qlik.com/t5/QlikView/Bar-chart-sort-by-data-difference/m-p/308450#M1187112 2011-08-30T22:32:40Z