Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How could I define by default the date system in a selection list?

Hello,

I need some help for doing this sample action :


When I open a qvw, I want a by default value for the list of selection 'Delivery date' . The default value is the system date

How could I define by default the date system in a selection list?


I 've used variable : LET Date_Jour = Today( );

and I've tried differents way in the document parameter.

on open document : field = date_field

string to serach : =$(Date_Jour)

But no way.

I missed something I think

Thank you in advance

Stephane

Labels (1)
3 Replies
avinashelite
MVP
MVP

Hi,

Please you trigger on opening the document.

Steps:Go to document properties>Triggers> on open add action > set feild > filed name > value like today()

rwunderlich
MVP
MVP

Specify your search string without the $(). ie

=Date_Jour


The $() is causing it

be evaluated. For example

1/1/2014 = 4.965243296921549e-4

-Rob

http://masterssummit.com

http://robwunderlich.com

aveeeeeee7en
Specialist III
Specialist III

Try:

on open document : field = date_field   (don't use = sign)

string to serach : =Date(Today())  ( use = sign)

Regards

Aviral Nag