topic Re: Sort a Bar Chart Based on One Value in QlikView

Sort a Bar Chart Based on One Value

lain_ — Wed, 24 Jun 2020 22:23:54 GMT

I have a pivot table like the one below. I am graphing this as a bar chart where N, Y are the x-axis, % is the y-axis and each A% and B% pair are the bars. Is there a way to sort this on the x-axis based on the A% value. For instance, here YA% is 0 whereas NA% is 3. YA% would be to the left of NA% on the x-axis on the bar chart. The NB% and YB% values do not matter in this sort.

		%
N	A	3
	B	1
Y	A	0
	B	10

Re: Sort a Bar Chart Based on One Value

vamsee — Fri, 26 Jun 2020 15:28:21 GMT

Sorting a pivot table or bar chart can be done under the sort tab. You can sort it by the expression you are using.

if you are looking for something like

Re: Sort a Bar Chart Based on One Value

lain_ — Fri, 26 Jun 2020 15:40:53 GMT

Say I have a chart like this. How do I sort it only based on the Desired orange bar, where the orange bars go in descending order. The values of the bar I calculated using an expression that has references to the dimensions.

Re: Sort a Bar Chart Based on One Value

Saravanan_Desingh — Sat, 27 Jun 2020 00:22:47 GMT

Sample data:

tab1: LOAD 2006+IterNo()-1 As Year, Ceil(Rand()*1000) As Desired, Ceil(Rand()*1000) As Real AutoGenerate 1 While IterNo()<=10;

Re: Sort a Bar Chart Based on One Value

Saravanan_Desingh — Sat, 27 Jun 2020 00:25:33 GMT

Two ways you can do.

Dimension: Year

Expression: Desired and Real

Make Desired as your first Expression.

Re: Sort a Bar Chart Based on One Value

lain_ — Mon, 29 Jun 2020 14:46:09 GMT

To clarify, the problem is that the desired and real values are both generated by the same expression. Please refer to my table on the original post.

Re: Sort a Bar Chart Based on One Value

vamsee — Mon, 29 Jun 2020 15:37:51 GMT

Can you please explain how do you have two bars for each year but in the sample data you mentioned only one metric.

It would be easier if you can share your qvw.

Re: Sort a Bar Chart Based on One Value

lain_ — Tue, 30 Jun 2020 15:43:46 GMT

The qvw file is attached with made up data. How would I sort the chart with b=1 going in descending order?

Re: Sort a Bar Chart Based on One Value

vamsee — Wed, 01 Jul 2020 13:25:53 GMT

Unfortunately, I am not able to find a solution to this, for now, you use your expression in sort tab under b

This will work when one year (a) is selected. I tried searching the community for this and couldn't find much useful solutions.

https://community.qlik.com/t5/New-to-QlikView/sort-by-ascending-order-in-bar-chart-with-two-dimensions/m-p/1214130

https://community.qlik.com/t5/New-to-Qlik-Sense/Sort-barchart-with-two-dimensions-by-measure/m-p/1180171

https://community.qlik.com/t5/New-to-QlikView/2-Dimension-Bar-Chart-Sorting/m-p/966667

With the 3rd option, you will be able to create a chart similar to

Re: Sort a Bar Chart Based on One Value

lain_ — Wed, 01 Jul 2020 14:51:31 GMT

Thank you for the effort. I think my problem is misunderstood. I want the sort the chart by rearranging the values on the x axis. So in the test.qvw I linked earlier, you see that each 'year' (a) is associated with odd numbers from 1 to 9 (b)(excluding 11). How do I sort the year (a) so that the associated 1 values (from b) are going in descending order. So in the test.qvw dashboard I have, it would be sorted like 2018, 2015, 2017, 2016 in this order. Looking at the blue bars associated with the value 1 (from b), they go in descending order from left to right. The odd numbers from 1 to 9 (from b) though, should be kept in ascending order.

Re: Sort a Bar Chart Based on One Value

lain_ — Thu, 02 Jul 2020 14:45:07 GMT

I got the answer here: https://community.qlik.com/t5/QlikView-App-Development/Sort-Dimension-1-of-Multiple-Bar-Chart/m-p/1724363

Thank you to everyone who helped.