"Go to sheet" action for button doesn't work

[pjn12345]

Hi everyone

When you use the formula editor to enter the sheet name to where the button should jump you, the action doesn't work.

So for example if I select the sheet first from the drop down the action works.

If I edit the object again and click on the formula button it will then show it as ='My Sheet Name'

If I go out and test the button (without editing the formula) it will then not work anymore.

My goal is to calculate the sheet name but if I can't even get it working with a static value then it's not going to work.

Tested on Cloud and On-prem with same results

Thanks

Regards,

Pieter

[Aditya_Chitale]

Hi,

When you click on the the formula button, are you clicking "Apply" ? If you are doing so, qliksense will correct the formula and add single quotes on your sheet name due to which the name gets considered as string and not actual sheet reference (according to my assumption).

If you want it to work, try to remove the single quotes and equal to sign without actually entering the formula tab. The button will then work as usual.

=' My Sheet Name '

Remove the red part without entering formula window.

Hope this helps.

Regards,

Aditya

[pjn12345]

Hi Aditya - Yes, nothing wrong with formula. Problem is if they don't want you to use formulas then why include the option? So it looks like it is a bug. I can get the button working by just selecting but I want it to be calculated via formula.

Not sure where to log bugs.

Thanks

[Aditya_Chitale · Accepted solution]

Hi @pjn12345 ,

Sorry  for the late response but what you  are saying is not completely true. Yes, you cannot pass  sheet name in formula and expect to navigate on that sheet when you click the button.

But you can pass the sheet id instead in your formula in single quotes. 

eg: if(getselectedcount(city), 'sheet1_id', 'sheet2_id').

You can find the sheet id in the URL.

Refer this link to find sheet id: https://community.qlik.com/t5/New-to-Qlik-Sense/how-to-find-sheet-ID-in-Qliksense/td-p/1511561

Regards,

Aditya

[pjn12345]

Thanks Aditya - will go that route thanks. Think they should disable the formula button and only allow you to use dropdown list.