Perform an 'action' when user selects something

[#1]

Hello,

I want to create a link between 2 tables. When the user selects option 1 in table A, qlikview should automatically select option 5 in table B. But this should only happen on this certain sheet.

I know you can perform Actions on buttons and on activation of a sheet, but can you also perform Actions on selection, and if so, how?

Thxs

[jonathandienst]

Hi

You can set actions on a field changes or selections, but they are not limited to a particular sheet.See Document Properties | Triggers.

If you fire a macro, you could filter for the sheetname and only perform the selection if you are in the required sheet.

Regards

Jonathan

[#3]

He,

You can add an action to a field. Go to document settings, tab Triggers and then field even triggers.

But maybe there is another solution for your problem.

You could make two transparent text objects and layer them above your table. Add actions to these text objects.

hope that helps.

[#4]

Thanks for your replies!

I was able to set a variable that changes from 0 to 1 when you select option 1 in Table A on sheet X.

Now I was looking at the possibilities you mentioned under document settings and those are rather limited, so i'm afraid a macro has to be written when my variable changes.

My knowledge of macros is very limited, could someone tell me what I should write in macro to do the following:

If VariableP=1

Then select option 5 in table B

Thanks a lot!