sorting problems.

[#1]

hello~

i have a problem with chart sort.

my bar chart is sorted by numeric in the dimension (hour)

ex) 00   01   02   03   04   05   06   07   08   09  10  11  12   13   14   15   16   17   18  ~~~~ 23

but i want it

   07   08    09    10    11   12 ~~~~       06

how can i do this??

please let me know.

Thanks in advance.

[Anonymous]

Hey,

You may use this custom sorting implementation on your dimension

PFA..

Best regards,

Chinna

[Anonymous · Accepted solution]

hi, please check this great post from Barry

Creating a custom sort order - The Qlik Fix! The Qlik Fix!

I personally like method 1

[#4]

Hi Dear,

Create Inline field

Load * Inline [

Hour, SortOrder

00,06

01,07

02,08

03,09

04,10

05,11

06,12

07,01

08,02

09,03

10,04

11,05

];

map the field Hour to your Hour field.

In the chart properties, Sort tab, use sort by expression =only(SortOrder)

in ascending order.

Hope this will work.

Regards,

Lalit