Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

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

View solution in original post

6 Replies
Highlighted
Partner
Partner

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

Highlighted
Not applicable

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

Highlighted
Not applicable

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

View solution in original post

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

okey then you answered your question

Highlighted
Not applicable

thanks