Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Sort Dimension 1 of Multiple Bar Chart

In the qvw file I attach, how would I sort dimension a of the graph based on the % value of b = 1 in descending order.  So looking at the blue bars where b = 1, they have different heights. I want to sort the graph so that the a dimension goes from 2018, 2015, 2017, 2016 in this order from left to right. After rearranging the a dimension values like this, you'll see that the blue bars where b = 1 are sorted in descending order. Note that all the other values in b do not matter in this, and I would like to keep the values of b in ascending order. Is there anyway to do this?

1 Solution

Accepted Solutions
Highlighted
Anonymous
Not applicable

you want to sort the chart by sum(val) for b=1 in descending order?
Goto sorting tab, for a i defin ethe formula =sum({<b={1}>} val) / sum({<b={1,3,5,7,9}>} total <a> val) in descending order
for b I untag everything. you may define your sorting order for b 

now i get the order of year 2018, 2015,2016,2017

View solution in original post

1 Reply
Highlighted
Anonymous
Not applicable

you want to sort the chart by sum(val) for b=1 in descending order?
Goto sorting tab, for a i defin ethe formula =sum({<b={1}>} val) / sum({<b={1,3,5,7,9}>} total <a> val) in descending order
for b I untag everything. you may define your sorting order for b 

now i get the order of year 2018, 2015,2016,2017

View solution in original post