Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cwitman1
New 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
Honored Contributor

Re: Sorting Date in Line Chart

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

4 Replies

Re: Sorting Date in Line Chart

please post a sample application to demonstrate the issue

thanks

regards

Marco

ahaahaaha
Honored Contributor

Re: Sorting Date in Line Chart

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
Contributor

Re: Sorting Date in Line Chart

Hi,

just set the order by number.

viveksingh
Contributor II

Re: Sorting Date in Line Chart

You can sort it under sort options.

If not, Can you post your app?

Community Browser