Sorting not proper on bar chart

[chetan_surana]

Hi,

I am trying to sort the bar chart on the basis of month and app names here .  THe Month year should be displayed in ascending order which is correct , but however the counts for each month should be stacked in descending order ...higher ones on top for each month ..but i get random results in between

Attaching the file . Help appreciated on the same ! 

[Michiel_QV_Fan]

Like this?

[chetan_surana]

The same doesnt work for rest of the files

[Michiel_QV_Fan]

You need to change the sorting of all charts individually

[chetan_surana]

The same report when i select current as parameter in list box the count distorts for e.g. see Mar 2012 Attaching the qvw doc .Also if possible please correct the qvw and send it across ...cannot see the images .  Thanks in advance !

[chetan_surana]

HELP Required

[Michiel_QV_Fan]

I've looked into your app.

If you disable the Dimension limit from APP_NAM I see a big improvement in what you try to accomplisch.

I enabled the Dimension limit again but set the sort for Apps to descending. Now I see a nice chart as your description suggests.

Please review your app as attached.

[chetan_surana]

Thanks for the reply Michiel,  But thats the problem ..when i select one month and display descneding sort its fine but when i display for all the months again there are places where it doesnt follow the order .

Say for example in your qvw file : March month starts with higheest 640 which is as per req but in between the order loses 228,237,240...whereas it shoudl be reverse

[chetan_surana]

Hi Michiel,

I found the issue ..the reason is the dimension of list box is not included in the chart , ...if i delete the listbox dimension from the sql query and then load the chart on the basis of Month , apps the stacks get ordered perfectly ..But the moment i add them in the query it changes ..Now how do i sort on the basis of this ??

[Michiel_QV_Fan]

can you attach the reloaded app. (I can't reload it of course )