Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
victor_greffet
Partner - Contributor III
Partner - Contributor III

Chart today's date

Hi Community,

After loading data, I put a combined Chart in order to visualize dates, good. I'd like to know if it's possible to display the chart at the today's date because when I open the app, I have to scroll until fouding my dates :

Capture12.PNG  -->      Capture11.PNG

Do you have an idea ?

Thank you,

Victor

9 Replies
YoussefBelloum
Champion
Champion

you have to use the sorting option, and use sorting expressions, maybe like this:

Max(DATE_FIELD) DESC

Anonymous
Not applicable

Also under Presentation you can set the Scroll Alignment to Start or End.


This was introduced a few version ago and I find it very useful on occasion.

Maybe not be what you are after though if you have loads of future dates.

victor_greffet
Partner - Contributor III
Partner - Contributor III
Author

Thanks for your reply,

If I put :

Max(CanonicalWeekYear)<'2017-50' in the sorting expression of my dimension (CanonicalWeekYear) nothing happen, how would you formulate ?

victor_greffet
Partner - Contributor III
Partner - Contributor III
Author

Yes i already try this nice option but it still to far from my today's data

YoussefBelloum
Champion
Champion

in the sorting area (i forget where it is exactly on qliksense), just put Max(CanonicalWeekYear) (with DESC option)

Anonymous
Not applicable

Unfortunately I don't think it is possible out of the box then.

Could be done in a bespoke extension, but I have not seen any such open source extension out in the wild.

victor_greffet
Partner - Contributor III
Partner - Contributor III
Author

I see what you mean,

but it doesn't work, even if i put a date in the expression.

thks

Lauri
Specialist
Specialist

Would it work to limit the chart to only a small number of future dates? If you don't want to see them, then why not use set analysis to filter them out?

victor_greffet
Partner - Contributor III
Partner - Contributor III
Author

I finally did that and it works well... Giving a view of 100 days using max(today(1)+100) as maxDate Capture.PNG