Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

christophebrault
Valued Contributor

Select value in a field when sheet activation

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,

1 Solution

Accepted Solutions
Not applicable

Select value in a field when sheet activation

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

Than it have to work fot you.

4 Replies
Not applicable

Select value in a field when sheet activation

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
Valued Contributor

Select value in a field when sheet activation

Hi,

Sorry but it doesn't work...

Look what i get :

selectinfield.JPG

Semaine is my field name.

What's wrong with this ?

Thanks

Not applicable

Select value in a field when sheet activation

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

Than it have to work fot you.

christophebrault
Valued Contributor

Select value in a field when sheet activation

It Works !!

Thanks a lot

Community Browser