Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
jwmonroe
Contributor II

Sorting Grouped Bar Charts

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

2017-04-12_9-37-12.bmpHow

1 Solution

Accepted Solutions
neelamsaroha157
Valued Contributor II

Re: Sorting Grouped Bar Charts

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

5 Replies
vinieme12
Esteemed Contributor II

Re: Sorting Grouped Bar Charts

try sorting by Y-Value

or

sort by expression >> The chart expression >> descending

Re: Sorting Grouped Bar Charts

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?

neelamsaroha157
Valued Contributor II

Re: Sorting Grouped Bar Charts

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

jwmonroe
Contributor II

Re: Sorting Grouped Bar Charts

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

jwmonroe
Contributor II

Re: Sorting Grouped Bar Charts

Sunny:

As always, thanks again for responding.

Jeff