Default Selection is not working for date field

[arusanah]

Hi Friends ,

 we recently upgraded from sept 2017 qliksense version to April 2019 version. in my previous version I used default selection extension to set default date it was working fine . post upgrade same extension seems to work fine for string values  but doesn't work for dates. 

  In previous version I used = max(date) and it was working fine . but now it doesn't do anything. we tried reinstalling extension & restarting servers but no change.  

Any suggestion?

[JordyWegman]

Hi Arusanah,

You can try the Qlik Sense Dynamic Default Bookmark Selection On Open: https://www.youtube.com/watch?v=d85WIgy35Ig

Jordy

Climber

[tresesco]

Try using formatting the date value. Try like:
= Date(max(date) , 'yourdateformat')

[EliGohar]

Hi @arusanah 

Probably the extension you worked with in Sep 2017 version is old and not support advanced versions.

I can recommend on SheetEvents extension which can be downloaded from here: 

https://github.com/iviasensio/SheetEvents

I've just tried to configure what you're asking for in my environment (Qlik November 2018) and it worked, please try this:

Regards,

Eli.

[arusanah · Accepted solution]

Hi Team,

Thank you all for your time & suggestion. I found out a way to tackle it . I wrapped max(date) in Num() and works fine .
if(getselectedcount(Date-A)=0,num(max(Date-A)),Date-A) this works for perfectly fine for me.