Date Picker Default Date

[rsmithy]

I want the date picker to default to a date,  Max(DateInTable)  when the user goes to a sheet.  I refer to this post:  https://community.qlik.com/t5/App-Development/Set-date-range-picker-to-default/m-p/1661063  to explain what i want.  The answer in that post is pretty simple,   you configure the datepicker  startdate    and enddate to set the default date range.  Set them to the same date to get a default date.   However that is not filtering any of the chart objects on the sheet.  It does set the text box values in the date picker when you open it.

In fact, the Qlik Help docs seem to say exactly that:

• Set the date to show when the date range picker is opened with Start date.

How do you get the charts to be filtered by a default date picker value when a user goes to it, as opposed to populating the start and end dates in the date picker when you open it?

[albertovarela · Accepted solution]

That configuration affects the date picker object but it doesn't apply the selection.  Have you tried setting up an action at the sheet level to select the dates you want?

I think if you combine a dynamic bookmark and a sheet action  you can achieve the behavior you a looking for

[rsmithy]

Thanks.  The dynamic bookmark solution works with the date field in a standard filter.    (Goodbye  date picker we barely knew ye).    I wish there was a less brittle way to do it, since whenever you change some other default condition you have to make a new bookmark and remember to recreate the search condition in the date filter.    I couldn't get the sheet actions to do the job but the docs say you cannot select a date field value with this sheet action,  if I read it correctly.

[Mahmoud]

Bonjour, 

Excusez moi j'ai le même problème et je n'ai pas réussi à combiner un signet et une action comme vous l'avez indiqué, en fait ce que je veux c'est que les dates initiales dans le Date picker soient

=(Date1>=Date(AddMonths(Today(1)-1,-1)+1)) and (Date1<=Date(Today(1)-1))

est ce que ça peut se faire? 

Merci d'avance,