topic Re:navigation in QlikView

Re:navigation

t_vijay_qlik — Wed, 25 Nov 2020 16:16:04 GMT

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

Re:navigation

vishsaggi — Sun, 29 Jul 2018 03:45:00 GMT

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

Re:navigation

BalaBhaskar_Qlik — Sun, 29 Jul 2018 12:37:03 GMT

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.

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

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.