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

Default X-axis on Bar Chart to minimize scrolling to the most recent date

Hello All,

Customer is requesting if it's possible to have the the bar chart default to the most recent date so they don't have to scroll to the right everytime they open the Qlikview app.  By default, the Bar chart displays on the first date data is available (see screenshot #1), what we'd like it to default to the current date (screenshot #2).  Any assistance would be greatly appreciated.

 

Thanks!

2 Replies
saumyashah90
Specialist
Specialist

Option1: Under Sort-> Uncheck all, check Expression and underexpression add your date field.

and under Dimension box, keep datefield in top and remove sort for other fields (attached image)

 

Option2: Under sort->Uncheck all, check Load Order.

and under Dimension box, keep datefield in top and remove sort for other fields (attached image)

cteruya
Contributor
Contributor
Author

Thanks for the response Saumyashah90.  What your suggestion does is reverse the display of the chart in descending order (see Screenshot3) from today's date which is nice but isn't exactly what I'm looking for. 

Can the chart keep the same display (accending order by date) and the scroll bar stay furthest to the right to highlight the most recent data (see Screenshot4) by default so the users don't have to scroll everytime the open the app?

Thanks!