Skip to main content
Announcements
You can succeed best and quickest by helping others to succeed. Join the conversation.
cancel
Showing results for 
Search instead for 
Did you mean: 
ralph_graham
Partner - Creator
Partner - Creator

Grouped Bar Chart Sort Problem

Hello,

I have a sort problem with a grouped bar chart in QlikView. It is for the number grades by year and have created a sort order field in the script so that A* is first, A is second, B is third  and so on.

The problem I have is when I add another dimension, in this case year, and it throws up an odd exception. See the image which shows E last when obviously it should be between D and F. I've tried various combinations in the Sort tab of the bar chart with no success. For information I use alt() around the Grade dimension as it was not sorting even more incorrectly without it.

Any suggestions would be appreciated.

Thanks,

Ralph

1 Reply
ralph_graham
Partner - Creator
Partner - Creator
Author

Fixed now. My expression for count of grades was using a variable to look at max selected year - 2 whereas my sort field was only looking at the current year so when there was no grades for the max year then the sort order added these to the end of the sort order. Simply added the max year -2 to the set and worked fine.