Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Navigate from Table to another sheet

Hi

I have a Straight Table with different fields.

each field has a specific sheet.

Now how can i navigate to that respective sheets by clicking on each fields.

for better understanding:- please see the attachment


Please come with a Solution As soon as Possible

Thanks,

Dileep.

1 Solution

Accepted Solutions
Nicole-Smith

Settings > Document Properties > Triggers > Field Event Triggers > [Company Name] > On Select > Layout > Activate Sheet

Then in the Sheet ID box:

=pick(match([Company Name], 'Test1', 'Test2', 'Test3'), 'SH01', 'SH02', 'SH03')

You need to replace the 'SH01', 'SH02', 'SH03' with the sheet IDs from your .qvw file (the same goes for the company names).  What I have above is just an example.

View solution in original post

2 Replies
Nicole-Smith

Settings > Document Properties > Triggers > Field Event Triggers > [Company Name] > On Select > Layout > Activate Sheet

Then in the Sheet ID box:

=pick(match([Company Name], 'Test1', 'Test2', 'Test3'), 'SH01', 'SH02', 'SH03')

You need to replace the 'SH01', 'SH02', 'SH03' with the sheet IDs from your .qvw file (the same goes for the company names).  What I have above is just an example.

Not applicable
Author

Its Working Fine .

Thankyou Smith.