Macro question

[#1]

I am trying to do the following:

I have a straight table chart on one sheet which shows summary data.  When the user clicks on one row within the table, I need to go to another sheet that displays the details of that record.

I think this requires a macro although I’m not sure and I don’t have any experience using macros in QV.  The requirement is pretty straightforward – when the users select one row of data on the active sheet it should go to another sheet.

Any help would be greatly appreciated.

[Anonymous]

No need for macro, you can use action:

Action type - layout

Action - activate sheet

Sheet ID - =if(count (distinct RowId)=1,'SH03')

Assuming RowId is a dimension in your table, and you want to switch to Sheet SH03.

Assign this action to event "Field RowIs - on select"

[#3]

I went to:

Settings

Sheet Properties

Triggers Tab

Sheet Object Event Triggers

OnActivate - Edit Actions

Add

Layout

Activate Object

=if(count (distinct proj_nbr_id)=1,'SH17')

The proj_nbr_id is a dimension in my table.

I'm not clear on the next step:

Assign this action to event "Field RowIs - on select"

Where can I find this?

[Anonymous · Accepted solution]

Close... 🙂

Go to Document properties, not sheet properties
Triggers tab
field events triggers
find field distinct proj_nbr_id
On Select - add action
Add
Layout
Activate Object
=if(count (distinct proj_nbr_id)=1,'SH17')

[#5]

This worked - thanks!