topic Re: Chronologically Sorting in QlikView

Chronologically Sorting

Wed, 21 May 2014 04:35:42 GMT

Hello!

I have a bar chart where the X axis uses the field PERIOD which has the following date format: YYYY/MMM

For example:

I want to sort the X axis chronologically (first order by year and then by month: january, february, march...), but I couldn't do it so far.

In order to build the PERIOD field, I used: YEAR (DATE) & '/' & MONTH (DATE).

How could I do this?

Thank you!!!

Wed, 21 May 2014 04:38:18 GMT

in the sort expression you provide this and say Ascending.

Date#(PERIOD,'YYYY/MMM')

Anonymous — Wed, 21 May 2014 04:47:39 GMT

Use monthname(Date) which will give you year month in numeric format.

Then it will easily sort out.

moreover you can also use

OR you can also use

date#(makedate(year(Date),month(Date),1),'YYYY/MMM')

tresB — Wed, 21 May 2014 04:55:41 GMT

Nitin, Your second expression should be using Date() instead of Date#().

Anonymous — Wed, 21 May 2014 05:02:03 GMT

Right....