topic Re: Bar chart isn't sorting chronologically in QlikView

Bar chart isn't sorting chronologically

Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

I have a chart with 2 dimensions, one is

=month(Case_Created_Date)

the other is Cases_Category.

But when the chart shows up, the months aren't in order?

I promoted the month dimension to the top.

Case Created Date is made in the script, by this

date(floor(Date(CreatedDateNum, 'MM/DD/YYYY'))) AS Case_Created_Date

I have to floor it and date it to get 01/01 as 1/1

Any ideas to get this to sort starting from January?

dberkesacn — Wed, 05 Jul 2017 16:25:10 GMT

try load inline and force the sort order with that, after use sorting tab / expression in the chart properties

LOAD * INLINE [

Month,Month_NO

Jan,1

Feb,2

...

];

Then in list box of Month Go to Sort Tab>Expression write the Month_NO,

Daniel

Wed, 05 Jul 2017 16:28:34 GMT

How do I link that back to my chart? Dimension as the new MonthNO??

Wed, 05 Jul 2017 16:33:51 GMT

I got a temporary fix by chart sorting it by numeric value

dberkesacn — Wed, 05 Jul 2017 16:34:39 GMT

in the table where you have this:

"date(floor(Date(CreatedDateNum, 'MM/DD/YYYY'))) AS Case_Created_Date"

make a month field from CreatedDateNum for example Case_Created_Month and make a new table with that name plus extend it with a sort field.

TableCaseCreatedMonthForSorting

LOAD * INLINE [

Case_Created_Month,Month_NO

Jan,1

Feb,2

...

];

Daniel

dberkesacn — Wed, 05 Jul 2017 16:35:54 GMT

okey then you answered your question

Wed, 05 Jul 2017 18:33:15 GMT

thanks