Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Default Selection is not working for date field

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?

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

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.

View solution in original post

4 Replies
Highlighted
Partner
Partner

Hi Arusanah,

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

Jordy

Climber

Work smarter, not harder
MVP
MVP

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

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:

image.png

Regards,

Eli.

Highlighted
Creator II
Creator II

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.

View solution in original post