5 Replies Latest reply: Aug 11, 2017 2:52 PM by Kaushik Solanki

Line Graph - Inverting Time Base on the X-Axis

Michael Porco Aug 11, 2017 12:03 PM

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

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

Kaushik Solanki Aug 11, 2017 1:04 PM (in response to Michael Porco)

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
Like Show 0 Likes (0)

Actions
- Re: Line Graph - Inverting Time Base on the X-Axis
  
  Michael Porco Aug 11, 2017 1:09 PM (in response to Kaushik Solanki )
  
  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
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: Line Graph - Inverting Time Base on the X-Axis
    
    Kaushik Solanki Aug 11, 2017 2:30 PM (in response to Michael Porco)
    
    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
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: Line Graph - Inverting Time Base on the X-Axis
      
      Michael Porco Aug 11, 2017 2:38 PM (in response to Kaushik Solanki )
      
      That worked.
      
      Thanks very much.
      
      Michael
      
      Like Show 0 Likes (0)
      
      Actions
      - Re: Line Graph - Inverting Time Base on the X-Axis
        
        Kaushik Solanki Aug 11, 2017 2:52 PM (in response to Michael Porco)
        
        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
        
        Like Show 0 Likes (0)
        
        Actions

Go to original post