topic Re: Add a link to another sheet in a formula in QlikView

Add a link to another sheet in a formula

fredericvillemi — Fri, 16 Oct 2015 09:44:27 GMT

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 — Fri, 16 Oct 2015 09:48:12 GMT

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 — Fri, 16 Oct 2015 10:15:58 GMT

By using actions or triggers you can do this.

fredericvillemi — Fri, 16 Oct 2015 11:10:47 GMT

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 — Fri, 16 Oct 2015 11:27:12 GMT

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 — Fri, 16 Oct 2015 11:29:18 GMT

ok thanks

i presumed it was not possible but i now have confirmation