topic Re: Sorting not proper on bar chart in QlikView

Sorting not proper on bar chart

chetan_surana — Thu, 19 Apr 2012 11:45:07 GMT

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 !

Re: Sorting not proper on bar chart

Michiel_QV_Fan — Thu, 19 Apr 2012 12:14:34 GMT

Like this?

Sorting not proper on bar chart

chetan_surana — Thu, 19 Apr 2012 14:10:53 GMT

The same doesnt work for rest of the files

Sorting not proper on bar chart

Michiel_QV_Fan — Thu, 19 Apr 2012 14:12:56 GMT

You need to change the sorting of all charts individually

Re: Sorting not proper on bar chart

chetan_surana — Thu, 19 Apr 2012 15:11:10 GMT

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 !

Re: Sorting not proper on bar chart

chetan_surana — Tue, 24 Apr 2012 07:20:55 GMT

HELP Required

Re: Sorting not proper on bar chart

Michiel_QV_Fan — Tue, 24 Apr 2012 08:11:11 GMT

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.

Re: Sorting not proper on bar chart

chetan_surana — Tue, 24 Apr 2012 09:17:29 GMT

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

Re: Sorting not proper on bar chart

chetan_surana — Wed, 25 Apr 2012 13:29:31 GMT

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 ??

Re: Sorting not proper on bar chart

Michiel_QV_Fan — Wed, 25 Apr 2012 13:43:23 GMT

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

Re: Sorting not proper on bar chart

SunilChauhan — Wed, 25 Apr 2012 13:48:04 GMT

see the attched file

Re: Sorting not proper on bar chart

chetan_surana — Wed, 25 Apr 2012 18:50:19 GMT

Its not correct April 2012 -- >first stack is 419 ,521, 391,905,747 its randomly arranged .. iwant all the stacks in descending order for each month

Re: Sorting not proper on bar chart

chetan_surana — Wed, 25 Apr 2012 18:57:36 GMT

i had to remove all the unnecessary dimensions from the sql while loading and only use ones which are in chart and then do order by desc. In chart -sort ---i did numeric asc and load order desc ..This works ... why doesnt it take extra dimensions ??