Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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.

View solution in original post

Not applicable
Author

Its Working Fine .

Thankyou Smith.