Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my dashboard, I have a Multi-box object as a filter with several dimensions.
I need fix values on one or two of these dimensions just for when the dashboard is opened, in order to it presents data filtered according these dimensions in the multi-box.
How I can do that?
Set the trigger on Opening the document to select these values.
Setting>>Document Setting>>Triggers>> On Opening>>Type in the field name and the field value.
Here is a thread that may be of interest to you. I know it says macro, but the solution given there uses document actions instead which makes it much easier
Settings>sheet Properties>Triggers.. you can put a trigger on activate to make the
How about just saving the doc with the selections made?
I already do that, but it's not working
Thanks!
How do your users access the application? You could save a bookmark, then give a URL to the users that opens the doc and applies the bookmark.
Set the trigger on Opening the document to select these values.
Setting>>Document Setting>>Triggers>> On Opening>>Type in the field name and the field value.
A word of caution against OnOpen triggers...they can be problematic. For example, I had persistent browser crashes with IE10 when using OnOpen triggers. Once they were removed the crashes stopped.
I would always minimise use of triggers if possible.
You can put a trigger on opening the QVW that makes the selections in the fields you want.
Settings > Document Properties > Triggers > Document Event Triggers > OnOpen > Add Action
Here you will add Action Type "Selection" with an Action of "Select In Field"
Both ways: vía URL and direct from server...
Because of that, I need fix the defaults...