topic Re: permanant selection in QlikView

permanant selection

Thu, 05 Sep 2013 08:59:43 GMT

Hi,

Is it all possible to create a permanent selection that automatically comes on when you open an application?

Any response would be greatly appreciated.

Cheers

Chris

Re: permanant selection

swuehl — Thu, 05 Sep 2013 09:04:25 GMT

You can use an OnOpen document trigger (Settings - Document Properties) with a Select - Select in field action to initiate an selection when opening the document.

This will not be permanent, i.e. can be changed by the user making other selections.

If you want a permanent selection, maybe look into set analysis with its field modifiers.

Re: permanant selection

markodonovan — Thu, 05 Sep 2013 09:05:13 GMT

Hi Chris,

Have a look at settings-doc properties-triggers, here you can add an OnOpen trigger that you can add actions to do things like set fields and activate particular sheets.

Hope this helps.

Mark

http://practical-qlik.com

https://twitter.com/PracticalQlik

http://practical-qlikview.tumblr.com

Re: permanant selection

Thu, 05 Sep 2013 09:18:27 GMT

Hi Chris,

if you able to select "Always one Selected value" in your list box,then you may see the permanant selection while opening your dashboard. Ref the attached image

Re: permanant selection

stigchel — Thu, 05 Sep 2013 09:27:24 GMT

If you really want to make selections permanent, you may want to look at section access and data reduction based on section access. The user has to login to the document and can only see the values you set in section access (load script)

Re: permanant selection

Thu, 05 Sep 2013 09:35:02 GMT

Hi Chris,

There are two simple options which you can use here :

1. Set a trigger on open of a document using Document properties :

After this, add an Action/Trigger :

Action type : Selection

Action : Select in Field

Here you can make some particular selection in a field which will always happen when you will open the document.

(This can be changed by changing the field and selection whenever required)

2. Another way is, if you have any list box containing multiple values then set that list box to "Always One Selected Value" (This check box you can check in Properties, General tab only after you have selected atleast one value in list box.). Once checked, select the value you want an save the document.

This way the same selection will happen whenever you will open the document. This can also be changed as and when required.

Apart from these 2 options, I think it can also be achieved using Set analysis but I am not sure about that.

Hope this helps!