topic Sorting in bar chart in QlikView

Sorting in bar chart

Wed, 30 Nov 2011 01:38:34 GMT

I am pulling data from oracle database. Its a date field. I don't want the entire date, so I am using to_char(Date, 'Mon YY') to extract Month and year.

I am using that in qlikview bar chart. But I am not able to sort it in Jan to Dec. Since it is a string am not able to sort.

Any help would be appreciated.

Thanks

Sorting in bar chart

Sokkorn — Wed, 30 Nov 2011 04:16:43 GMT

Hi Saaty*,

Let try this in sort expression : =Match(MonthField, $(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

Let me know if this one solve your issue.

Regards,

Sokkorn Cheav

Sorting in bar chart

jagan — Wed, 30 Nov 2011 05:26:02 GMT

Hi Saaty,

While pulling the data from the database you do ordering by date column. Then in the chart you set the sort order as "Load Order".

Hope this helps in fixing your issue.

Regards,

Jagan.

Re: Sorting in bar chart

Michiel_QV_Fan — Wed, 30 Nov 2011 07:27:19 GMT

You can create a new date field for your bar chart.

Reload your datefield again and add transformations:

LOAD Date,

date(date#(month(Date)&' '&year(Date), 'MMM YYYY'), 'MMM YY') as New_date

FROM ..........

Step 1: create month and year from date

Step 2: define the combined date field format by using date#

Step 3: define the conbined date field in the desired format with date

Now Qlikivew will indentify the field [Mon YY] as date and you can sort your bar chart.

Re: Sorting in bar chart

Wed, 30 Nov 2011 14:56:24 GMT

Thanks guys! It worked