Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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

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