Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cwitman1
Contributor III
Contributor III

Sorting Date in Line Chart

Trying to sort this the other way so May 2017 is on the far right instead of far left.

Sorting tabs are not changing anything.

date-sorting.jpg

1 Solution

Accepted Solutions
ahaahaaha
Partner - Master
Partner - Master

Hi Chris,

As far as I understand, such a situation has developed due to the format of the month-year dimension.

You need to show Qlik Sence the correct sort order. You can go in two ways.

1) on the sorting tab, select the "by expression" sorting and arrange the dimension, for example by date (see table 1 in the attached file).

2) More cumbersome, but also working way. When loading your data, show the sorting of the Month - Year field using the additional field (in the example shown, this field is ID). Then when constructing a diagram on the "Sorting" tab, you should also select the "By expression" option and specify the sorting by the special additional field (ID in this case - Table 2 in attached file).

Regards,

Andrey

View solution in original post

4 Replies
MarcoWedel

please post a sample application to demonstrate the issue

thanks

regards

Marco

ahaahaaha
Partner - Master
Partner - Master

Hi Chris,

As far as I understand, such a situation has developed due to the format of the month-year dimension.

You need to show Qlik Sence the correct sort order. You can go in two ways.

1) on the sorting tab, select the "by expression" sorting and arrange the dimension, for example by date (see table 1 in the attached file).

2) More cumbersome, but also working way. When loading your data, show the sorting of the Month - Year field using the additional field (in the example shown, this field is ID). Then when constructing a diagram on the "Sorting" tab, you should also select the "By expression" option and specify the sorting by the special additional field (ID in this case - Table 2 in attached file).

Regards,

Andrey

rospigliosi
Creator
Creator

Hi,

just set the order by number.

viveksingh
Creator III
Creator III

You can sort it under sort options.

If not, Can you post your app?