topic Re: Navigatin to a Sheet depending on a Variable in App Development

Navigatin to a Sheet depending on a Variable

nejc_rudel — Tue, 03 May 2022 17:10:47 GMT

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.

Re: Navigatin to a Sheet depending on a Variable

Pierremouth_ — Wed, 04 May 2022 09:19:57 GMT

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 !

Re: Navigatin to a Sheet depending on a Variable

nejc_rudel — Wed, 04 May 2022 09:26:50 GMT

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?

Re: Navigatin to a Sheet depending on a Variable

vish123 — Wed, 04 May 2022 09:37:59 GMT

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..

Re: Navigatin to a Sheet depending on a Variable

nejc_rudel — Wed, 04 May 2022 10:12:30 GMT

Tried... 😞 Won't work.

Re: Navigatin to a Sheet depending on a Variable

Pierremouth_ — Wed, 04 May 2022 12:57:35 GMT

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 $().

Re: Navigatin to a Sheet depending on a Variable

nejc_rudel — Mon, 09 May 2022 07:34:12 GMT

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.

Re: Navigatin to a Sheet depending on a Variable

mattphillip — Tue, 10 Jan 2023 11:08:12 GMT

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

Re: Navigatin to a Sheet depending on a Variable

jbhappysocks — Tue, 10 Jan 2023 12:22:30 GMT

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.

Re: Navigatin to a Sheet depending on a Variable

mattphillip — Tue, 10 Jan 2023 12:33:50 GMT

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.

Re: Navigatin to a Sheet depending on a Variable

jbhappysocks — Tue, 10 Jan 2023 12:45:43 GMT

Strange, that was the first thing I tried and it's not working for me. What do you have in your variable?

Re: Navigatin to a Sheet depending on a Variable

mattphillip — Tue, 10 Jan 2023 13:40:22 GMT

For each sheet you are navigating from, there's a sheet action populating the vWhatSheet variable with the sheet ID taken from the URL e.g. ='0334b574-be05-4809-a033-3a685b2bc1fb'.

On the destination sheet, the back button has a navigation action 'Go to a sheet defined by a sheet ID' and in the expression box I've got ='$(vWhatSheet)'

Re: Navigatin to a Sheet depending on a Variable

alanw58 — Fri, 13 Dec 2024 11:29:31 GMT

I'm on Nov-24 (SR1) Enterprise & still not working for me.

So Button Nav Action: ='$(vSheet)' does nothing. Doesn't error but no action