Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Manually Sort the Bar Chart

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

MVP
MVP

Re: Manually Sort the Bar Chart

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

Re: Manually Sort the Bar Chart

Hi sreenivas,

Its not working,when I select Year & Month

sreenivas
Contributor III

Re: Manually Sort the Bar Chart

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

Not applicable

Re: Manually Sort the Bar Chart

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

Re: Manually Sort the Bar Chart

Hi sreenivas,

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

sreenivas
Contributor III

Re: Manually Sort the Bar Chart

Check This Attached file.

Not applicable

Re: Manually Sort the Bar Chart

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

Re: Manually Sort the Bar Chart

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

Community Browser