Navigatin to a Sheet depending on a Variable

[nejc_rudel]

Hi guys, does anyone know  how to convince Qlik Sense to navigate to specific Sheet depending on a Variable?

I'm using a button > Actions & Navigation > Go to Sheet ... 

You can pick one from the list, ok... works fine, but if you just touch a formula window, action will stop working.

Any ideas how to make a formula to navigate to specific sheet?

Thnx.

[Pierremouth_]

Hi !

I'm not sure how you did write the sheet name in the formula window, but on this panel, it should look like this:

and not like this, which is the case on your screenshot. 

By default, Qlik will add the equal sign when you validate the formula. Remove them when on the Actions and Navigation panel directly and it should work !

[nejc_rudel]

Ok, that is correct, works fine if you want to navigate to one sheet in particular. But what if you want to use formula like this (depending on a Variable):

=IF(vNav2=101, 'CMD - TPS - PERFORMANCE',
IF(vNav2=102, 'CMD - TPS - VALORACIÓN',
IF(vNav2=103, 'CMD - TPS - ASIGNACIÓN'))) 

I tried removing ' ' but ain't gona work. Any ideas?

[vish123]

Hi Nejc,

Put the variable like this and try ... for instance 

=IF($(vNav2)=101, 'CMD - TPS - PERFORMANCE',
IF($(vNav2)=102, 'CMD - TPS - VALORACIÓN',
IF($(vNav2)=103, 'CMD - TPS - ASIGNACIÓN'))) 

Also make sure your that your variable is evaluating correctly to match with 101 or 102 etc.. 

[nejc_rudel]

Tried... 😞  Won't work.

[Pierremouth_]

Hi Nejc, 

can you create a variable and put Vish's formula within ?

Then call this variable in the action and navigation button using the $().

[nejc_rudel]

Hi Pierremouth!

Tried your option in Desktop version (Nov 2021)  and won't work. I'll give it a try on server version and I'll let you know.

Thanx for your help.

[mattphillip]

Hi Nejc,

I'm trying to do something similar and I was just wondering whether you had any luck getting this to work?

Thanks,

Matt

[jbhappysocks]

Hi! I'm not getting it to work with formulas whatsoever.

Until someone comes up with an actual solution, you can use this is workaround. Put several buttons, one for each sheet, in a container and use your variable as a show condition instead.

[mattphillip]

Thanks for the reply. I've actually gotten it to work. In the button navigation action I added some single quotes to have ='$(vWhatSheet)'. Now it works great.