Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())
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?
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
Check the file. I have 2 fields - year and month.
See documents settings - triggers to the the actions on open.
Worked for me!
Hi Denisse
You can try deleting and then do it again
Regards!
or too, you can try with your date field.
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
Excelent, work for me!