Sorting by y-axis not possible

[#1]

Hi everyone

I'm experiencing some trouble with sorting a chart by y-axis.

In the tutorial from qlikview (first steps.pdf) there is an "y-axis"-option mentioned, but I can't find it in the "Sort"-tab from Qlikview 11.

I've also seen it on several screenshots. It seems like this option is missing but I dont know why...

On the Screenshot below you can see the options I can choose from when sorting a chart (although the descriptions of the fields are german, they're very similar to the english ones and if you dont understand something just ask 😞

This is what it shoul look like (ignore the red box):

Does anyone ever had this problem too or knows how to fix it?

I've already searched in the qlik View forum but I didn't find anything helpful 😕

Thank you

[Gysbert_Wassenaar · Accepted solution]

That's weird. That option seems to have disappeared in QV 11.2 SR11 (and possible SR10). That would be no problem if promoting the expression to the top position in the Priority list box would actually function. But the chart won't sort by the expression values if you do. That looks like a bug to me. The workaround is to sort the dimension by expression and use the same expression.

[#3]

What type of chart object is the properties window in your screen shot referencing?

[maximiliano_vel]

Well I have the same problem, the option just disappeared, using any type of chart object.

[#5]

It's a bar chart

[#6]

Ok so I'll try your workaround and maybe search in the Bug group if there's already a post about this. thank you

[#7]

Ok this workaround is a good solution.

For everyone who doesn't know exactly what he has to do:

1. Go to the sort preferences of the chart.

2. Put your y-axis dimension (in my case "Land") to the top.

3. Choose your y-axis dimension and check the option "Expression".

4. Put there the value you've written in the "Expression"-TAB (left to the sort tab)

5. Save

Now it should look like this (in my example i used the option descending):