Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

michaelpo
New Contributor III

Line Graph - Inverting Time Base on the X-Axis

Hello,

Very new to Qlik Sense.  First time poising a question.

I have a simple line graph and I have months on the X-axis.  Currently the months run from oldest to newest from left to right.  I would like to invert this within the graph to have it run from newest to oldest from left to right.

Currently:  January to December.

Want:  December to January.

I thought I would be able to invert the scale easily using the selection options but it's not the case.

Thanks in advance.

Michael

1 Solution

Accepted Solutions

Re: Line Graph - Inverting Time Base on the X-Axis

Hi,

For that you must change the continuous axis.

To change this go to Appearance -> Y Axix -> Off the Continues Mode -> Also uncheck "Use Continues Scale".

After doing this you will be able to change the sorting.

Regards,

Kaushik Solanki

5 Replies

Re: Line Graph - Inverting Time Base on the X-Axis

Hi Michael,

Welcome to Qlik Family. Feel free to post your queries on community.

Now to resolve your query all you need to do is click on the chart -> on right side you will see the properties -> one of the tab in property is Sort -> Here you will see the first option as Month -> Click on the drop down menu -> Change Auto Mode to custom -> Now you will see an option to sort by number -> Select Descending

Thats it.

Your chart axis will be sorted as you want.

Regards,

Kaushik Solanki

michaelpo
New Contributor III

Re: Line Graph - Inverting Time Base on the X-Axis

Thanks for pointing this out.  I should have mentioned that I'm not able to use the sorting property in my app for my line graph.  I receive a message indicating that "You cannot change sorting when using a continuous dimension axis."

Is there a work around or another line graph type?

Michael

Re: Line Graph - Inverting Time Base on the X-Axis

Hi,

For that you must change the continuous axis.

To change this go to Appearance -> Y Axix -> Off the Continues Mode -> Also uncheck "Use Continues Scale".

After doing this you will be able to change the sorting.

Regards,

Kaushik Solanki

michaelpo
New Contributor III

Re: Line Graph - Inverting Time Base on the X-Axis

That worked. 

Thanks very much.

Michael

Re: Line Graph - Inverting Time Base on the X-Axis

Hi,

Please mark the post as correct.

The Reason to do this is

1. Close the post

2. To allow other users to know exact answers.

Regards,

Kaushik Solanki