Solved: Add a link to another sheet in a formula - Qlik Community

fredericvillemi · ‎2015-10-16

Hello,

i have a textbox in which i would like to add a link to another sheet in a formula

Is it possible ?

For example my textbox would be :

='There is a problem on site : ' & maxString(SITE)

Where the Site name would be a link to another Sheet (and maybe a selection of this site)

Is it possible ? or do you have created a workaround ?

Thanks

Anonymous · ‎2015-10-16

I suppose that the only Workaround would be to create 3 textobjects

while 2 of them have Action to activate the required sheet

in this case you can define text in bold, what is not possible as you requrie

The best site is London and the worst one is Paris

drawback: you need to define and maintain 3 objects and makes it more difficult

Anonymous · ‎2015-10-16

define an Action in our textbox

Action Layout, Activate Sheet, maxString(SITE)

users see message and Need to press TextBox and will be transferred to the required Sheet

jsingh71 · ‎2015-10-16

By using actions or triggers you can do this.

fredericvillemi · ‎2015-10-16

Sorry i was not precise enough.

I would like the link to be on the site name only.

The Textbox would have a long text with maybe several links to click on.

Example :

The best site is London and the worst one is Paris

and have links on both bold texts

Anonymous · ‎2015-10-16

I suppose that the only Workaround would be to create 3 textobjects

while 2 of them have Action to activate the required sheet

in this case you can define text in bold, what is not possible as you requrie

The best site is London and the worst one is Paris

drawback: you need to define and maintain 3 objects and makes it more difficult

fredericvillemi · ‎2015-10-16

ok thanks

i presumed it was not possible but i now have confirmation