Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
t_vijay_qlik
Contributor III
Contributor III

Re:navigation

Hi all,

When ever we need to navigate to other sheet example from sheet1 to sheet2 how this can be achieved in qlikview?

for example

in sheet1 when ever we click on any record as say branch etc the it should navigate to chart?

thanks

vijay

1 Solution

Accepted Solutions
balabhaskarqlik

It can be :

1). Text Box / Button - Action - Activate Sheet on the Actions tab of the properties window of the text box or button. If you also want to select a value in a field then you can add a Select in Field action.

OR

2). Activate Sheet with sheet number = pick(match([Tab Number], 1,2), 'SH02', 'SH03') in Document Properties - Triggers

OR

3). In Script, load an island table, with sheet names along with the sheet id of each one, then add a trigger to the sheet name field, using =only(sheetid) as the function and add your list box containing that field. It will have all the sheet names, you can select the required.

View solution in original post

2 Replies
vishsaggi
Champion III
Champion III

Using button or textobject -> Action -> Activate sheet -> Giving sheet ID

balabhaskarqlik

It can be :

1). Text Box / Button - Action - Activate Sheet on the Actions tab of the properties window of the text box or button. If you also want to select a value in a field then you can add a Select in Field action.

OR

2). Activate Sheet with sheet number = pick(match([Tab Number], 1,2), 'SH02', 'SH03') in Document Properties - Triggers

OR

3). In Script, load an island table, with sheet names along with the sheet id of each one, then add a trigger to the sheet name field, using =only(sheetid) as the function and add your list box containing that field. It will have all the sheet names, you can select the required.