Discussion board where members can get started with QlikView.
I have a chart with 2 dimensions, one is
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?
I got a temporary fix by chart sorting it by numeric value
View solution in original post
try load inline and force the sort order with that, after use sorting tab / expression in the chart properties
LOAD * INLINE [
Then in list box of Month Go to Sort Tab>Expression write the Month_NO,
How do I link that back to my chart? Dimension as the new MonthNO??
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.
okey then you answered your question