Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
christophebrault
Specialist
Specialist

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,

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
1 Solution

Accepted Solutions
Not applicable

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

Than it have to work fot you.

View solution in original post

4 Replies
Not applicable

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
Specialist
Specialist
Author

Hi,

Sorry but it doesn't work...

Look what i get :

selectinfield.JPG

Semaine is my field name.

What's wrong with this ?

Thanks

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin
Not applicable

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

Than it have to work fot you.

christophebrault
Specialist
Specialist
Author

It Works !!

Thanks a lot

Inscrivez vous à ma Newletter Qlik
DoNotMissQlik- Connect with me on Linkedin