Navigating between sheets using buttom

[Amit_B]

Hi experts,

I created a button that, when clicked, should go to another sheet. The sheet will be selected by the user with a dropdown list (Variable Input - vSheet).
I tried to set a condition so the user will move to the sheet he chose, but it didn't work. 

 =If(vSheet = 1, 's1', If(vSheet = 2, 's2', 's3'))

How can this be done? And if not possible, what are the alternatives?

For tests I use QS Desktop version February 2022, client's QS version is May 2022.

Thanks!

[steeefan]

You seem to want to navigate to sheets called 's1', 's2' and 's3'. Are these really your sheets' names? Try using their actual names or their IDs. The latter you can find in the address bar of your browser after /sheet/.

[MartW · Accepted solution]

Hello @Amit_B ,

try and use the define sheet by sheetID option.

then it is important that you always make sure that your variable is within quotes (make it a string)

in your dropdown you need to select the option to dynamiclly fill the dropdown. with a value~label|(extra options)

then it should work

[Amit_B]

Thanks for the reply.

How can I know what the SheetID is in QS Desktop?

[steeefan]

Start Qlik Sense Desktop, then open it in a browser: http://localhost:4848/hub/my/work

[Amit_B]

Thanks alot!