topic Re: Set selection on open sheet in QlikView

Set selection on open sheet

Thu, 12 Dec 2013 11:23:54 GMT

Hi,

I have a sheet that is to show a specific selection in a type column. I load the table as main.type and it holds Type A, Type B and Type C. Now in my sheet "MAIN" i want it to automatically select "Type A" and not show results for Type B or Type C.

I have thought about doing this either by inputting something extra in my LOAD statement, or perhaps by using a trigger, but I cannot get it to work either way. Any ideas?

Cheers,

Re: Set selection on open sheet

Thu, 12 Dec 2013 11:27:57 GMT

You may go at Sheet properties, Triggers and add an OnActivate trigger action to remove all selections, adding a Clear selection action and after that add an A field selection.

Re: Set selection on open sheet

Anonymous — Thu, 12 Dec 2013 11:28:15 GMT

Nils

On the Sheet Properties go to the Triggers tab and create a trigger to do the selection OnActivateSheet.

BEWARE: Some triggers do not work on the Ajax, so do test that scenario.

Best Regards, Bill Markham

Re: Set selection on open sheet

Thu, 12 Dec 2013 11:37:41 GMT

How do I set the triggers? I'm not really good at that . I assume I would set it as:

1. OnActivateSheet >> Select Possible >> " "

2. OnActivateSheet >> Clear All

3. OnActivateSheet >> Select in Feild >> Feild = main.type | Search String = 'Type A'

I cannot seem to get this to work however...

Re: Set selection on open sheet

Thu, 12 Dec 2013 11:46:23 GMT

If your intent is not simply select the field type A for example but avoid the user to select another dimensions (B and C) You can set triggers to select the right dimension at activate sheet and block another dimensions like:

First of all, clear all selections using a clear all action;
Do the right selection to the Field A;
If you do not want the user select another dimensions, set a trigger to block fields type B and C;
After this at another other sheets except main, release the fields B and C for user;

To set your triggers, right click at sheet, properties then go to triggers tab,

Hope this helps,

João Dias

Re: Set selection on open sheet

Thu, 12 Dec 2013 12:34:45 GMT

thank you! this is exactly what i want, however i think im getting the field setup wrong. to select fields i do this:

3. OnActivateSheet >> Select in Feild >> Feild = main.type | Search String = 'Type A' -- correct?

and then to exclude i set it up as:

3. OnActivateSheet >> Select Exclude >> Feild = main.type = 'Type B' or 'Type C'

Re: Set selection on open sheet

Thu, 12 Dec 2013 12:50:17 GMT

You must set the field value with no quotes such like Type A not 'Type A'.

Also create two actions for Type B and Type C for exclusion

As Bill exposed previously beware with ajax non working scenarios

Re: Set selection on open sheet

Thu, 12 Dec 2013 12:58:13 GMT

ok, i think i got the selection correct now, however after running the script i get a different result than what i get when i just select "Type A" in my selections list. Why is that?

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:04:39 GMT

Sorry if I miss your explanation,

Did you said that you ran your script again and the results differs when you get values for Type A selections made manually from when do you activate the sheet and the trigger fires?

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:21:24 GMT

yes, exactly. i have no idea why that is? it also does not high light "Type A" in the selection box i have - i would have expected it to. is it suppose to do that?

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:27:47 GMT

Maybe another triggers are setting some dimension value to another field and data is correlated at it.

To make sure what you have selected you may put a Current Selections object and debug what´s happening at both situations;

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:32:04 GMT

i have made sure that there are no other triggers selected. i also have a selections box present, but i have not seen the "Type A" selection show up in this box. please have a look again at the actions i use:

Clear All

Select in Field >> Field(main.type) Search String(Type A)

Select Excluded >> (main.type = Type B and Type C)

that is exactly how i have it written now. please correct this as you see fit .

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:45:09 GMT

Thinking about it I got 2 hypothesis

1) If your data have rows with null or different types except A, B or C the result may differs cause you set the action to select types A, then excludes B and C, but do not say what to do when null or another type appears. So select A and exclude B and C differs from only Select A

2) Your triggers may set wrong at exclusion. To exclude this values you first of all must set a trigger to exclude B types then set another trigger to exclude C types. Do you combine exclusion with both types B and C?

Hope this helps

Re: Set selection on open sheet

Thu, 12 Dec 2013 13:56:43 GMT

hmm.. i think you first guess may be correct. the table may have NULLs in it. however if it cannot sort on that then this trigger thing will not do. i will need to do this in some sort of load statement.

one more question regarding this trigger. i my selection "main.type = Type A suppose to show up in my current selections box if implemented correctly?

Re: Set selection on open sheet

Thu, 12 Dec 2013 14:19:22 GMT

i worked around a bit more with this and it seems like i need to swithc my stands on triggers - they just may do the trick ! the only thing now is the second selection, to be able to select Type B and Type C at the same time. now i have it set up as two different selections:

Select in Field >> Field(main.type) Search String(Type B)

Select in Field >> Field(main.type) Search String(Type C)

(i do this so that i can be able to easily track the changes). however doing this it only selects Type C, that is the last selection in the row. how do i get it to select both?

Re: Set selection on open sheet

Thu, 12 Dec 2013 14:36:45 GMT

One way to do this is to clear all selections and select the both types B and C,

then create a Bookmark to it, at trigger event set to apply Bookmark and set the bookmark id as reference

Re: Set selection on open sheet

Thu, 12 Dec 2013 14:41:07 GMT

im sorry, i didnt really follow that... could you possibly explain more in detail, step-by-step?

Re: Set selection on open sheet

Thu, 12 Dec 2013 14:56:07 GMT

Yeap 🙂

1) First make sure that all current selections are clear.

2) Select both Type´s (B and C) with CTRL key pressed ;

3) Create a new bookmark at bookmark menu (The mine one is at Portuguese, but i believe that prints could by helpful)

3) Give a friendly name to you bookmark

4) After did it, press Ctrl + Shif + B to view bookmark lists, then search to you bookmark Id

5) Go to sheet triggers and set action Bookmars, Apply new bookmark, then set the Bookmark id

This will apply the combined types

Re: Set selection on open sheet

Fri, 13 Dec 2013 08:25:30 GMT

amazing! works perfectly - thank you!

(the screens helped, Portuguese was no hindrance )