topic Re: How do I sort X-axis date values in ascending order? in QlikView

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

Thu, 18 Dec 2014 13:49:52 GMT

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-15

Dec-16

Sep-15

Dec-16

Dec-15

Dec-16

Dec-15

Dec-16

Dec-15

Dec-16

Nov-14

Dec-16

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

anbu1984 — Thu, 18 Dec 2014 13:54:07 GMT

Add this expr to sort tab

=Date(X_Axis_Date_field,'MMM-YY')

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

Michiel_QV_Fan — Thu, 18 Dec 2014 13:54:11 GMT

Sid,

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

A date field will be ordered ascending.

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

Thu, 18 Dec 2014 13:56:48 GMT

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

Best,

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

Thu, 18 Dec 2014 13:59:09 GMT

Michiel,

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

Thanks,

Sid

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

Thu, 18 Dec 2014 14:02:17 GMT

See screenshot

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

My Column name in Excel is Formatted Final NGI Target Date

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

MarcoWedel — Thu, 18 Dec 2014 14:04:19 GMT

change your load script like:

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

...

FROM yourexcelfile;

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

Thu, 18 Dec 2014 14:05:00 GMT

Tibor,

Chart is not sorting on State.

Thanks,

Sid

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

Thu, 18 Dec 2014 14:11:53 GMT

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.

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

anbu1984 — Thu, 18 Dec 2014 14:19:48 GMT

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

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

Thu, 18 Dec 2014 14:26:12 GMT

Thank you Anbu:)

It worked.