topic Re: Re: Automatic selection in QlikView

Automatic selection

Thu, 28 Nov 2013 10:30:56 GMT

Hi,

I have two tables where one is the parent table and one is a child table. As per usual, one parent can have several children, however the child only has one parent. Now if I select one parent, the child table will show me the correct kids, and grey out the rest, but in order for me to actually select the kids (make them green) i need to click on them. Is there any way for me to negate that step? I.e. is there any way for me to automatically select the kids just by selecting the parents?

Cheers,

Nils

Re: Automatic selection

tresB — Thu, 28 Nov 2013 10:38:24 GMT

Try using a trigger : Select Possible

Re: Automatic selection

Thu, 28 Nov 2013 12:16:57 GMT

how would i do that? im not really good at expressions ...

Re: Automatic selection

tresB — Thu, 28 Nov 2013 12:19:42 GMT

Could you please share your sample app?

Re: Automatic selection

michael_maeuser — Thu, 28 Nov 2013 12:25:43 GMT

you can run a macro

sub SelectPossibleValues

ActiveDocument.Fields("ChildField").SelectPossible

end sub

additionally set a trigger on the sheet for running macro:

=if(GetSelectedCount(ParentField)>0, 'SelectPossibleValues')

Re: Re: Automatic selection

Thu, 28 Nov 2013 13:14:01 GMT

thanks micheal, however i really dont know where to place this macro. i have attached a sample file of what i am trying to do to examplify this.

Re: Automatic selection

sundarakumar — Thu, 28 Nov 2013 13:52:46 GMT

Hi Nils,

You dont have to run macro for this purpose. This can be achived with triggers...

Go to Settings -> document Properties -> triggers ,then select the parent field and add 'select possible' trigger for all the child fields.

Please find the attachment which shows it clearly.

-Sundar

Re: Automatic selection

saumyashah90 — Thu, 28 Nov 2013 13:58:00 GMT

What will Select Possible do?
->When you chose a field Name for example shown below child1 then it will select(child1) and all possible values related to that field name

If you dont want to select two or more field names then
->'(Field1|Field2|Field3)'

Hope you will UnderStand this

Re: Re: Re: Automatic selection

tresB — Thu, 28 Nov 2013 14:00:26 GMT

It is always better to use trigger rather than a macro. PFA.

Re: Automatic selection

Thu, 28 Nov 2013 14:05:15 GMT

tnx, this worked perfectly!

Re: Re: Automatic selection

sundarakumar — Thu, 28 Nov 2013 14:50:10 GMT

Hi Saumya,

I cannot set the trigger for more than one field...

the example you have shown above is not working in the attachment...

I have tried all possible combinations like

child1|child2|child3

'child1|child2|child3'

(child1|child2|child3)

'(child1|child2|child3)'

can you please explain?

-Sundar