Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default selections on document opening

I have a list box where i have the option checked always one selected value and when i open the document i want the calendar defaulted to current year and month which seems to be not working when i use the option

Document properties->Triggers-> on open->action->

Select in field year=year(today())

Select in field month=Month(today())

Can someone advise what's missing?

This condition is not able to override the selections on the list box.

Thanks.

8 Replies
MK_QSL
MVP
MVP

Hope the Field name you wrote is accurate as QlikView is case sensitive...

year and Year is different

Also the field name should be without = sign

year

=year(today())

month

=Month(today())

Not applicable
Author

Yes i did check everything it's still not working though.

Does the impact falls from the list box having always one selected value and user selects different value and its get saved?

prieper
Master II
Master II

you may add a "Clear all" command before your selections.

Trigger actions work only, when deployed on server. On a local version always the last status/selection is saved (unless there are fieldrestrictions by section access).

Peter

Not applicable
Author

Check the file. I have 2 fields - year and month.

See documents settings - triggers to the the actions on open.

Worked for me!

Anonymous
Not applicable
Author

Hi Denisse

You can try deleting and then do it again1.PNG

Regards!

Anonymous
Not applicable
Author

or  too, you can try with your date field.

1.PNG

2.PNG

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Try this go to Document Properties -> Trigger -> Document Event Triggers -> OnPost Reload -> Add Actions -> Add -

Choose Clear Field and enter your Date Field. Then Add another actions choose Select in Field. In the Field section enter your DateFieldName, in the Search String Enter Year(Today()) and add another actions in the field Enter your DateFieldName in the search String Enter =Month(Today()).

This should work

Klaus
Contributor II
Contributor II

Excelent, work for me!