RE:Dynamic sheet reflect

[Chanty4u]

Hi all,

i have a dynamic table.

Wih in that   i have Dimension as  "Project"  .so my req is

When i click on any of the projct   it will redirect to the specific sheet?

How can i achve this? 

Thanks in advance.

Suresh

[sunny_talwar]

You should be able to add on select trigger based on selections you make in project field. Have you tried that?

[Anonymous]

IN THAT SHEET TO GIVE THE CONDITION IN LAY OUT IF(GETSELECTION(FIELDNAME='VAULE'),1,0)

[sathishkumar_go]

HI,

Please provide ur application sample data (atleast Project field value).

-Sathish

[sunny_talwar]

Try the attached application, but I would think that only one selection in Project will work since you cannot possibly go into two sheets at a single time.

Script to create three projects:

Table:

LOAD * Inline [

Project

A

B

C

];

Adjusted the sheet id for the sheets that I need to open

Finally added Activate Sheet trigger with the following Sheet ID

[Chanty4u]

hi ,

that table as stright table.    in that the dimension as project.  wen i select any prjct it will redirect to some specific sheet.

[Chanty4u]

i need hyperlink for that...  not usng trigggers

[sunny_talwar]

HyperLink to go to another sheet in the same qvw?

[Chanty4u]

yes sunny... exctly...is it psble? for perticular dimension?

[Chanty4u]

not that one.