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!
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)
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!