topic Re: How to Navigate from Table to another sheet in QlikView

How to Navigate from Table to another sheet

Fri, 27 Dec 2013 13:38:46 GMT

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.

Re: How to Navigate from Table to another sheet

Nicole-Smith — Fri, 27 Dec 2013 14:14:09 GMT

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.

Re: How to Navigate from Table to another sheet

Mon, 30 Dec 2013 03:29:53 GMT

Its Working Fine .

Thankyou Smith.