Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashwita
Contributor
Contributor

Requirement to autofit line chart in a single sheet without scrolling

I need to display 92 days data in a single line chart with running sum in Qliksense. The line chart should fit in a single sheet, without scrolling to the right side.

Since there's no autofit option in the dimension or measure, I'm not able to achieve the formatting as desired. When I use the function odd or even to limit the days then the running sum is not working properly. 

Kindly provide a solution where the line chart should either fit automatically into a single sheet or the running sum should take the data only for odd/even days. 

Labels (1)
1 Solution

Accepted Solutions
Andrei_Cusnir
Specialist
Specialist

Hello,

 

On my side when using Line chart, I was able to see the entire chart without scrolling, even though I had 100 days of data. You can try modifying the following settings:

  1. In Appearance > X-axis
  2. Un-check option "Continuous"
  3. Un-check option "Use continuous scale"
  4. Number of axis values: Max
  5. This should show all the data on the chart and remove the scroll option entirely:

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂

View solution in original post

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

On my side when using Line chart, I was able to see the entire chart without scrolling, even though I had 100 days of data. You can try modifying the following settings:

  1. In Appearance > X-axis
  2. Un-check option "Continuous"
  3. Un-check option "Use continuous scale"
  4. Number of axis values: Max
  5. This should show all the data on the chart and remove the scroll option entirely:

I hope that this information was helpful. In case I have misunderstood the use case scenario, please elaborate in details by providing additional information. However, if it has helped you resolve the issue, addressed your concerns or at least pointed you in the right direction, please mark it as Accepted Solution to give further visibility to other community members. 
 

Help users find answers! Don't forget to mark a solution that worked for you! 🙂