topic Re: Does it exists a correct syntax to use an action "Go to sheet" with an expression ? in App Development

Does it exists a correct syntax to use an action "Go to sheet" with an expression ?

herard_bertrand — Tue, 25 Jun 2024 11:44:14 GMT

Hello,

I want to use a "Go to Sheet" Action with a Variable.

I'm desperatly fighting with the syntax (And I'm starting to suspect there is a bug).

Let's says you have a sheet Named EXAMPLE.

I only manage to use the Action "Go to sheet" if the value of the parameter Sheet is exactly EXAMPLE (If I type directly the name on the keyboard), it doesn't works if it's =EXAMPLE or ='EXAMPLE' etc ...

So my concern is, I don't how to use an expression that will returns exactly EXAMPLE (and not even starting with a = ). As far as I know, a value EXAMPLE without quotes is an error in expressions

Does someone knows how to do this ?

Just to precise : I've already tried a huge number of syntax (using =, '', ch(39)&, $(), $(=), variables and mixes of all this).

It works easily in QlikView, the main difference is that, in QlikView ='EXAMPLE' works

Best regards

Re: Does it exists a correct syntax to use an action "Go to sheet" with an expression ?

lennart_mo — Tue, 25 Jun 2024 13:32:17 GMT

I can only think of a workaround using 'Go to a sheet defined by sheet ID', where you match the worksheet name from the input to the ID. Trying it with just the name is causing me problems as well.

Re: Does it exists a correct syntax to use an action "Go to sheet" with an expression ?

anat — Tue, 25 Jun 2024 13:54:03 GMT

can you select the sheet name from the dropdown button.