Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

victor_greffet
New 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

Tags (1)
9 Replies
YoussefBelloum
Esteemed Contributor

Re: Chart today's date

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

Max(DATE_FIELD) DESC

Re: Chart today's date

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
New Contributor III

Re: Chart today's date

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
New Contributor III

Re: Chart today's date

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

YoussefBelloum
Esteemed Contributor

Re: Chart today's date

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

Re: Chart today's date

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
New Contributor III

Re: Chart today's date

I see what you mean,

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

thks

laurischarf
Contributor II

Re: Chart today's date

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
New Contributor III

Re: Chart today's date

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