topic Re: Select by Default in QlikView

Select by Default

Wed, 11 Jun 2014 14:58:23 GMT

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?

Re: Select by Default

Wed, 11 Jun 2014 15:00:27 GMT

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

Re: Select by Default

nam — Wed, 11 Jun 2014 15:00:53 GMT

Settings>sheet Properties>Triggers.. you can put a trigger on activate to make the

Re: Select by Default

Jason_Michaelides — Wed, 11 Jun 2014 15:05:26 GMT

How about just saving the doc with the selections made?

Re: Select by Default

Wed, 11 Jun 2014 15:12:12 GMT

I already do that, but it's not working

Thanks!

Re: Select by Default

Jason_Michaelides — Wed, 11 Jun 2014 15:15:25 GMT

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.

Re: Select by Default

alec1982 — Wed, 11 Jun 2014 15:15:35 GMT

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.

Re: Select by Default

Jason_Michaelides — Wed, 11 Jun 2014 15:17:45 GMT

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.

Re: Select by Default

Wed, 11 Jun 2014 15:19:07 GMT

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"

Re: Select by Default

Wed, 11 Jun 2014 15:23:21 GMT

Both ways: vía URL and direct from server...

Because of that, I need fix the defaults...

Re: Select by Default

Jason_Michaelides — Wed, 11 Jun 2014 15:26:51 GMT

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.

Re: Select by Default

Wed, 11 Jun 2014 15:43:13 GMT

Thanks you all!

Re: Select by Default

Wed, 11 Jun 2014 16:02:47 GMT

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

Re: Select by Default

Jason_Michaelides — Wed, 11 Jun 2014 16:27:26 GMT

Select In Field action. Use this syntax for the values:

(Ene|Feb|Mar|Abr)

Or create a bookmark and apply that in the action.

Re: Select by Default

alec1982 — Wed, 11 Jun 2014 16:28:14 GMT

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.

Re: Select by Default

Wed, 11 Jun 2014 16:34:19 GMT

Thanks!!!

Re: Select by Default

Wed, 11 Jun 2014 16:34:39 GMT

Thanks again!