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

Bar chart isn't sorting chronologically

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?

file.png

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?

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
dberkesacn
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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

Not applicable
Author

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

dberkesacn
Partner - Creator III
Partner - Creator III

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

okey then you answered your question

Not applicable
Author

thanks