topic AW:Sorting of bar chart. in QlikView

Sorting of bar chart.

Tue, 19 Apr 2011 17:56:41 GMT

Sorting of bar chart.

IAMDV — Tue, 19 Apr 2011 18:43:50 GMT

Hi saffatwist,

You are doing right! I had checked your sort expression and it is perfect. However there is seems to be line break in your Classifiction Field. If you export the Classification Field to Excel and copy the text in to your sort expression it works fine. Or else you can try the below expression because it works for me...

=Sum ({$<Classification={'First class honours
'}>} [MeasureScore])/Sum (Total <ShortName> MeasureScore)

So the problem is with raw data. There is a line break and your 'First class hounours' is not getting evaluated in the sort expression. Using excel is the best way to troubleshoot with string data types.

Also uncheck other sort types (I am assuming that you are just testing them...)

I hope this helps and please mark the post answered if this helps!

Sorting of bar chart.

IAMDV — Tue, 19 Apr 2011 18:48:25 GMT

Just to add one more point - Your Subject field seems to be right, unlike the Classification Field. I would strongly recommend you to clean up the data in the script. You are having this problem because of Carriage Return.

Good luck!

AW:Sorting of bar chart.

Tue, 19 Apr 2011 19:17:46 GMT

Hello saffatwist,

DV is right. I tested it in a little other way. I took via copy/paste the value(!) directly out of the listbox. AND ... there is really a CR and/or a LF in your fieldvalue. Meanwhile I went to dinner, so I am too late with my answer.

=Sum ( {< Classification={'First class honours
'} >}MeasureScore)
/Sum (Total <ShortName> MeasureScore)

will work for the moment, but much better is, as DV still mentioned, cleaning the data during load.

Regards, Roland