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?
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
Macro for default Selections
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
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.
Both ways: vía URL and direct from server...
Because of that, I need fix the defaults...
Then you might need to use a trigger as suggested. Or else create a splash page with a button that applies the selections using actions.
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"
Thanks you all!
Thanks again to all!
I have another question:
How I can select several values of one dimension as default, using the similar trigger?
Thanks in advance
Select In Field action. Use this syntax for the values:
Or create a bookmark and apply that in the action.
If the values you want to select located within the same column change the trigger values to be like (Value1|Value2|Value3).
if the values are indifferent columns then create other triggers.
Retrieving data ...