topic Re: Perform an 'action' when user selects something in QlikView

Perform an 'action' when user selects something

Fri, 25 May 2012 12:05:41 GMT

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

Re: Perform an 'action' when user selects something

jonathandienst — Fri, 25 May 2012 12:16:47 GMT

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

Perform an 'action' when user selects something

Fri, 25 May 2012 12:17:30 GMT

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.

Perform an 'action' when user selects something

Fri, 25 May 2012 12:48:49 GMT

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!