topic Re: Manually Sort the Bar Chart in QlikView

Manually Sort the Bar Chart

Mon, 10 Sep 2012 06:18:43 GMT

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.

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 06:23:59 GMT

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

Re: Manually Sort the Bar Chart

jagan — Mon, 10 Sep 2012 06:36:08 GMT

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.

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 06:59:55 GMT

Hi sreenivas,

Its not working,when I select Year & Month

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 07:01:45 GMT

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

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 07:02:24 GMT

Hi Jagan,

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

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

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 07:11:23 GMT

Hi sreenivas,

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

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 07:28:11 GMT

Check This Attached file.

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 08:33:23 GMT

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.

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 08:38:29 GMT

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

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 08:55:56 GMT

Hi sreenivas,

You qvw file is correctly showing the desired result when nothing is selected,but its not working when,I select Year & Month

Thanks

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 08:58:16 GMT

Can you Add the qvw file

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 09:00:30 GMT

Hi sreenivas,

Its not possible,since I am working on the client machine.

Thanks

Re: Manually Sort the Bar Chart

sreenivas — Mon, 10 Sep 2012 11:43:29 GMT

add the Month field in the expression

Re: Manually Sort the Bar Chart

Mon, 10 Sep 2012 13:32:36 GMT

You can manually sort by using a Match expression in Chart Properties > Sort. See attached.