topic Re: Sort Order in QlikView

Sort Order

kevbrown — Tue, 11 Nov 2014 09:42:49 GMT

I have a chart and a graph that run off the same data. I need to sort both by a column called "CL_Q". This column shows the following values -

Qtr1, Qtr2, Qtr3, Qtr4, Nov-2013, Dec-2013, Jan-2014,Feb-2014, Mar-2014, Apr-2014, May-2014, Jun-2014,Jul-2014, Aug-2014, Sep-2014, Oct-2014.

Depending on the year I select my chart and graph will show either the quarters or the months, which works fine, however the sort order of the months is by name not date, so Apr-2014, Aug-2014 etc. How can i get it in the correct order in the chart properties and not in the script?

Thanks

Kev

Re: Sort Order

anbu1984 — Tue, 11 Nov 2014 09:47:51 GMT

Use expr Date#(CL_Q,'MMM-YYYY') on Sort tab

Re: Sort Order

kevbrown — Tue, 11 Nov 2014 09:54:08 GMT

Superb, thank you.

Re: Sort Order

MK_QSL — Tue, 11 Nov 2014 09:55:47 GMT

Define your Month-Year Field in sort expression

Go to Sort Tab

Write Below in Your Sort Expression

Date#(CL_Q,'MMM-YYYY')

This will consider your Month-Year Field as Numeric

Now you can sort by Ascending or Descending Order...