topic Re: Sorting Grouped Bar Charts in QlikView

Sorting Grouped Bar Charts

jmonroe918 — Wed, 12 Apr 2017 16:42:46 GMT

I have a grouped bar chart (By Mon/Yr). I would like to display the columns Top 10 from left (highest values) to right (lowest values) which when Ascending is selected in the Sort tab is selected works fine with all years, and when each year is selected.

However when I change the Sort to Descend, all years display correctly (Right to Left) but the individual years selected seem to show the Bottom 10.

How do I get the chart to sort left to right, highest to lowest for all years when they are selected?

Thanks

How

Re: Sorting Grouped Bar Charts

vinieme12 — Wed, 12 Apr 2017 16:56:19 GMT

try sorting by Y-Value

sort by expression >> The chart expression >> descending

Re: Sorting Grouped Bar Charts

sunny_talwar — Wed, 12 Apr 2017 17:00:38 GMT

Not sure what you are looking to do?? Why do you have single expression for each year? why not use Year as a dimension? What exactly are you looking to do?

Re: Sorting Grouped Bar Charts

neelamsaroha157 — Wed, 12 Apr 2017 17:23:06 GMT

Check this out. i don't know why you are using different expression for each year.

Re: Sorting Grouped Bar Charts

jmonroe918 — Wed, 12 Apr 2017 17:57:55 GMT

Neelam:

Based on the feedback received (from all 3 replies) and went to my chart and did exactly what you did in the attached.

I'm not sure why the expressions were created separately (I didn't create the original chart), but now I know better.

Thanks for the help.

Jeff

Re: Sorting Grouped Bar Charts

jmonroe918 — Wed, 12 Apr 2017 17:58:38 GMT

Sunny:

As always, thanks again for responding.

Jeff