Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Sorting by y-axis not possible

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 😞

sorting_options.png

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

WhaleCurveSort.png

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

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Sorting by y-axis not possible

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.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
MVP & Luminary
MVP & Luminary

Re: Sorting by y-axis not possible

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.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Re: Sorting by y-axis not possible

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

Partner
Partner

Re: Sorting by y-axis not possible

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

Not applicable

Re: Sorting by y-axis not possible

It's a bar chart

Not applicable

Re: Sorting by y-axis not possible

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

Not applicable

Re: Sorting by y-axis not possible

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):

solution.png