topic Re: Sorting by expression-value in a barchart in QlikView

Sorting by expression-value in a barchart

Mon, 20 Jul 2015 10:20:35 GMT

Hi all,

I am having some diffuculty sorting my bars in the bar chart according to a descending numeric value. I seem to have no problem doing this in my Straight Tables, as I go to Sort and then I choose my value-expression, called "Current Selections" as first priority and do sort by Numeric Value descending. When I do the same for the bar chart it just doesn't sort and remains sorted by the dimension (in this case "Country". Is there anyone who has come across this problem?

Re: Sorting by expression-value in a barchart

sunny_talwar — Mon, 20 Jul 2015 10:22:52 GMT

Try sorting your dimension (Country) by Y-Value descending:

Re: Sorting by expression-value in a barchart

awhitfield — Mon, 20 Jul 2015 10:25:27 GMT

Hi Espen,

can you upload an example qvw please?

Andy

Re: Sorting by expression-value in a barchart

Gysbert_Wassenaar — Mon, 20 Jul 2015 10:27:40 GMT

I think this is a bug (introduced in one of the last SR's). Sorting by an expression like this doesn't work afaict. Try promoting the Country dimension to the top position and choose the option Sort by Expression. Then enter the same expression you used for Current Selections again in the input box.

Re: Sorting by expression-value in a barchart

Mon, 20 Jul 2015 10:28:07 GMT

Hi,

I am unable to "Sort by" Y-value or state as you have in your image above. How did you get this?

Re: Sorting by expression-value in a barchart

Mon, 20 Jul 2015 10:29:17 GMT

Didn't make any difference to my sorting. 😞

Re: Sorting by expression-value in a barchart

Mon, 20 Jul 2015 10:30:27 GMT

That worked perfectly Gysbert! Thanks a lot 🙂

Re: Sorting by expression-value in a barchart

Gysbert_Wassenaar — Mon, 20 Jul 2015 10:30:45 GMT

He's using an earlier version of QV than you are.

Re: Sorting by expression-value in a barchart

sunny_talwar — Mon, 20 Jul 2015 10:32:03 GMT

To tell you the trust, I am not sure. I have this application that I worked on in the past and I checked the properties of a bar chart object in it. Seems to have the Sort by Y-value in it for a bar chart. Not really sure why its not there for you.

Re: Sorting by expression-value in a barchart

sunny_talwar — Mon, 20 Jul 2015 10:35:31 GMT

Gysbert‌, are you saying that I am using an older version? Currently I am working on SR12, (although the application was built on an older version) But I do see that option in the properties when I open sort tab. May be it has to do with what version the application was built in, rather than what version I currently have??

Re: Sorting by expression-value in a barchart

Gysbert_Wassenaar — Mon, 20 Jul 2015 13:39:57 GMT

Ah, I see that the old behaviour has been reinstated in SR12. I was using SR11. So I was in fact using an older version than you were