topic Macro question in QlikView

Macro question

Thu, 29 Mar 2012 15:57:27 GMT

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.

Macro question

Anonymous — Thu, 29 Mar 2012 16:24:28 GMT

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"

Macro question

Thu, 29 Mar 2012 20:09:51 GMT

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?

Macro question

Anonymous — Thu, 29 Mar 2012 20:15:19 GMT

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')

Macro question

Thu, 29 Mar 2012 20:50:14 GMT

This worked - thanks!