Re:navigation

[t_vijay_qlik]

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

[vishsaggi]

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

[balabhaskarqlik · Accepted solution]

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.