topic Re: Chart Sort in QlikView

Chart Sort

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a chart where I would like to set the sort to:

OCT-16

NOV-16

DEC-16

JAN-17

etc

Is it possible to pre-set a sort like this?

Thanks,

Daniel

Re: Chart Sort

varshavig12 — Fri, 21 Oct 2016 09:13:28 GMT

Fiscal Year

Re: Chart Sort

sunny_talwar — Fri, 21 Oct 2016 10:41:41 GMT

So are you hoping to always get the current Month as the first Month of the sort or is this always Oct based on your fiscal Year? If it is always Oct, you can try this:

Match(Month(Only({1}MonthYearField)), 10, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9)

Re: Chart Sort

maleksafa — Fri, 21 Oct 2016 11:07:23 GMT

you can do that in the script by loading the field as dual, the first value will be the date and the second value will be the sort order Year and MonthOrder (201512,201601,201602), and then in the chart you will sort based on numerical value asc.

Re: Chart Sort

Anonymous — Fri, 21 Oct 2016 11:41:53 GMT

Try this:

=	date(Field_Date,'MMM-YY')

Re: Chart Sort

Anonymous — Fri, 21 Oct 2016 11:44:37 GMT

The result will be