Manually Sort the Bar Chart

[#1]

Hi Everyone,

I need to display the bar chart order on the following basis

Apr-11

Apr-12

May-11

May-12

Where All these are values of field Monthname.

Also,thses values are coming after selecting Month & Year

(in above case,May-12)

How can I sort the Bar Chart?

Thanks.

[sreenivas]

In Sort Tab check the Expression and add the Month(FieldName) in ascending order.

[jagan]

Hi,

If you are arriving the Month field from a date field using MonthName() then use the below script

Dual(""Place you month script here", MonthEnd(DateField)) AS MonthName

Hope this helps you.

Regards,

Jagan.

[#4]

Hi sreenivas,

Its not working,when I select Year & Month

[sreenivas]

In expression add the Monthfieldname which you use to select in the Listbox.

[#6]

Hi Jagan,

I tried but its not working.What do you mean by this ?

Dual(""Place you month script here", MonthEnd(DateField)) AS MonthName

[#7]

Hi sreenivas,

I have added the fieldnames in expression,but still its not coming

[sreenivas]

Check This Attached file.

[#9]

Hi sreenivas,

I checked qvw file.Here bars are coming in following fashion:

Apr-11

May-11

Apr-12

May-12

and what I wanted is

Apr-11

Apr-12

May-11

May-12

Thanks.

[sreenivas]

In the attached file it shows the following month Order only same is shown in the qvw also.