topic Re: Default Selection is not working for date field in Visualization and Usability

Default Selection is not working for date field

arusanah — Fri, 16 Apr 2021 20:35:28 GMT

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?

Re: Default Selection is not working for date field

JordyWegman — Thu, 23 May 2019 12:55:38 GMT

Hi Arusanah,

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

Jordy

Climber

Re: Default Selection is not working for date field

tresB — Thu, 23 May 2019 12:58:56 GMT

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

Re: Default Selection is not working for date field

EliGohar — Mon, 27 May 2019 14:39:54 GMT

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.

Re: Default Selection is not working for date field

arusanah — Wed, 29 May 2019 15:39:25 GMT

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.