topic Select value in a field when sheet activation in QlikView

Select value in a field when sheet activation

christophebrault — Thu, 06 Oct 2011 07:35:47 GMT

Hi,

On my application, i'd like to select the curent week in a selection object when the sheet is opened.

In propriety of the sheet, i go to triggers and add action on the sheet, selection and select a field. Is it the right way ?

But then, i don't know what expression in have to use...

How can i do this ?

Thanks,

Thu, 06 Oct 2011 07:53:24 GMT

Hi Christopher,

What you should do is:

- make a variable in your script or frontend that generate the current week like week(today())

- make a trigger OnActivateSheet --> Select in Field --> fill in the variable

Succes, Halmar

christophebrault — Wed, 19 Oct 2011 09:21:53 GMT

Hi,

Sorry but it doesn't work...

Look what i get :

Semaine is my field name.

What's wrong with this ?

Thanks

Wed, 19 Oct 2011 09:24:57 GMT

You have to delete the '=' in the first field.

Than it have to work fot you.

christophebrault — Wed, 19 Oct 2011 09:30:07 GMT

It Works !!

Thanks a lot