topic Re: How could I define by default the date system in a selection list? in QlikView

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

Tue, 22 Jul 2014 10:24:43 GMT

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

avinashelite — Tue, 22 Jul 2014 10:36:15 GMT

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 — Tue, 22 Jul 2014 11:03:46 GMT

Specify your search string without the $(). ie

=Date_Jour

The $() is causing it

be evaluated. For example

1/1/2014 = 4.965243296921549e-4

-Rob

aveeeeeee7en — Tue, 22 Jul 2014 11:15:05 GMT

Try:

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

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

Regards

Aviral Nag