topic Re: How do I reverse the date on a timeseries? in QlikView

How do I reverse the date on a timeseries?

jleefjcapital — Thu, 21 May 2015 10:54:16 GMT

Currently, the data are being displayed latest to oldest from left to right. I would like to reverse this for a line graph. Is there a way via the tool to do this?

Re: How do I reverse the date on a timeseries?

Gysbert_Wassenaar — Thu, 21 May 2015 10:58:14 GMT

Change the sorting order of that dimension on the Sort tab of the properties window of the chart.

Re: How do I reverse the date on a timeseries?

manojkulkarni — Thu, 21 May 2015 10:58:27 GMT

You can change this using Sort Order of your dimension. Currently it might have sorted in descending order change it to ascending.

Re: How do I reverse the date on a timeseries?

jleefjcapital — Thu, 21 May 2015 11:02:01 GMT

Thank you both.

Re: How do I reverse the date on a timeseries?

jagan — Thu, 21 May 2015 11:07:56 GMT

Hi,

Try like this

Properties -> Sort -> Select Numeric -> Ascending

HOpe this helps you.

Regards,

Jagan.

Re: How do I reverse the date on a timeseries?

jleefjcapital — Thu, 21 May 2015 11:10:40 GMT

Thank you.

Re: How do I reverse the date on a timeseries?

buzzy996 — Thu, 21 May 2015 11:27:33 GMT

try this

Re: How do I reverse the date on a timeseries?

jleefjcapital — Thu, 21 May 2015 11:35:12 GMT

Thank you! It worked.

Re: How do I reverse the date on a timeseries?

buzzy996 — Thu, 21 May 2015 11:37:44 GMT

pls mark correct or helpful the best answer's!