How do I sort X-axis date values in ascending order?

[#1]

Hi,

I am new to Qlikview. I have created a bar chart, and displaying Total Values (Count) for a month.

Problem: How do I sort X-axis date values in ascending order

Subset of Data:

Jun-15

Dec-16

Dec-16

Dec-16

Dec-16

Dec-16

Dec-16

Dec-15

Dec-15

Dec-15

Dec-15

Dec-16

Sep-15

Dec-16

Dec-16

Dec-16

Dec-15

Dec-15

Dec-15

Dec-15

Dec-15

Dec-16

Dec-16

Dec-16

Dec-16

Dec-16

Dec-16

Dec-15

Dec-15

Dec-15

Dec-16

Dec-15

Dec-16

Nov-14

Dec-16

Dec-16

Dec-16

[anbu1984]

Add this expr to sort tab

=Date(X_Axis_Date_field,'MMM-YY')

[Michiel_QV_Fan]

Sid,

Is this date field a true date field in your script?

A date field will be ordered ascending.

[#4]

Go to Properties>Sort>State, then choose Ascending.

Best,

T

[#5]

Michiel,

I loaded data from the excel file as is. How can I make it a true date field in my script.

Thanks,

Sid

[#6]

See screenshot

Is that correct? as I am not getting the desired output

My Column name in Excel is Formatted Final NGI Target Date

[MarcoWedel]

change your load script like:

LOAD Date#(month, 'MMM-YY') as  month,

          ...

FROM yourexcelfile;

[#8]

Tibor,

Chart is not sorting on State.

Thanks,

Sid

[#9]

It isn't beacuse you use date as expression, not as dimension. Try using it as dimension, then you will be able to sort it.

[anbu1984 · Accepted solution]

If Final NGI Target Date is not date, then use Date#() as below