Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Manually Sort the Bar Chart

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.

14 Replies
sreenivas
Creator III
Creator III

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

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

Hi sreenivas,

Its not working,when I select Year & Month

sreenivas
Creator III
Creator III

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

Not applicable
Author

Hi Jagan,

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

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

Not applicable
Author

Hi sreenivas,

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

sreenivas
Creator III
Creator III

Check This Attached file.

Not applicable
Author

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
Creator III
Creator III

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