topic Re: Re: Hi, link in a table? in Qlik Learning Discussions

Using URL or Link from a QV Table

Wed, 06 Aug 2014 07:33:33 GMT

Hello,

In one table for each customer appears their e-mail.

Is it possible make clickable the e-mail address so that "outlook" starts directly ?

Re: Hi, link in a table?

teempi — Wed, 06 Aug 2014 07:52:06 GMT

Hi,

Assuming the email addresses are in a field called "email", you can try something like this in the expression:

= email & '<url>mailto:' & email

This should open the default e-mail client. Remember to change the representation type to "Link" in the chart properties.

-Teemu

Re: Hi, link in a table?

Wed, 06 Aug 2014 07:59:21 GMT

Thanks it seems it works..

But how i change the representation type to "Link" in the chart properties?

Re: Re: Hi, link in a table?

teempi — Wed, 06 Aug 2014 08:03:06 GMT

Representation can be changed from the "Expressions" tab in chart properties.

-Teemu

Re: Hi, link in a table?

Wed, 06 Aug 2014 08:07:03 GMT

No, i doesn't work..

Re: Hi, link in a table?

Jennifer_Moore — Wed, 06 Aug 2014 15:15:23 GMT

The format for the expression is 'Text for link' & '<URL>' & 'Static URL location' & field - Field is needed to customize the URL

It can be activated as a link in a straight/pivot table by going to the Expressions tab, selecting the expression, changing the Representation to link. This option does not appear in all chart types.

Re: Hi, link in a table?

Thu, 07 Aug 2014 06:48:39 GMT

Thanks it works!