topic Re: Chart today's date in App Development

Chart today's date

victor_greffet — Mon, 20 Nov 2017 14:09:20 GMT

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 :

-->

Do you have an idea ?

Thank you,

Victor

Re: Chart today's date

YoussefBelloum — Mon, 20 Nov 2017 14:12:50 GMT

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

Max(DATE_FIELD) DESC

Re: Chart today's date

Anonymous — Mon, 20 Nov 2017 14:31:31 GMT

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.

Re: Chart today's date

victor_greffet — Mon, 20 Nov 2017 14:33:44 GMT

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 ?

Re: Chart today's date

victor_greffet — Mon, 20 Nov 2017 14:35:00 GMT

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

Re: Chart today's date

YoussefBelloum — Mon, 20 Nov 2017 14:40:34 GMT

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

Re: Chart today's date

Anonymous — Mon, 20 Nov 2017 14:49:50 GMT

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.

Re: Chart today's date

victor_greffet — Mon, 20 Nov 2017 15:15:20 GMT

I see what you mean,

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

thks

Re: Chart today's date

Lauri — Mon, 20 Nov 2017 21:51:16 GMT

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?

Re: Chart today's date

victor_greffet — Thu, 23 Nov 2017 11:53:25 GMT

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