Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Bar chart sort by data difference

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.

The first item in the chart should therefore be the item that is the least balanced across my warehouses.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Bar chart sort by data difference

Probably sort by expression, maybe something along these lines sorted descending?

fabs(sum({<Warehouse={'one'}>} Inventory)
    -sum({<Warehouse={'two'}>} Inventory))

3 Replies
Not applicable

Bar chart sort by data difference

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.

MVP
MVP

Re: Bar chart sort by data difference

Probably sort by expression, maybe something along these lines sorted descending?

fabs(sum({<Warehouse={'one'}>} Inventory)
    -sum({<Warehouse={'two'}>} Inventory))

Not applicable

Re: Bar chart sort by data difference

Thanks allot for your info. its working fine

Community Browser