topic Re: Dimension + http link + straight table in QlikView

Dimension + http link + straight table

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We need to show all qlikview access point links in a qlikview table.For that we have captured all likns in an excel.

Here the link should be dynamic like if user clicks on any link it will redirect to that page.

Note:access point urls were in dimension.

Please find below image for reference.

Thanks..

Anonymous — Fri, 09 Dec 2016 17:40:29 GMT

Use a Straight Table.

MK9885 — Fri, 09 Dec 2016 17:42:44 GMT

if(Your Deimension='Value',

'www.google.com'&'<URL>'&'www.google.com',

'www.Yahoo.com'&'<URL>'&'www.yahoo.com')

Will redirect you to either yahoo or google links.

OR just

=Name & '<url>' & Link

=Name & '<url>www.yahoo.com'

nareshthavidishetty — Fri, 09 Dec 2016 17:49:18 GMT

Hi,

I need to redirect to the qlikview access point link.

Thanks..

MK9885 — Fri, 09 Dec 2016 17:51:13 GMT

Yes,

Instead of www.google.com or www.yahoo.com

you should paste your access point links

Ex:

=Yourdimensionhere&'<URL>'&'www.Qlikaccesspoint.com'

If you do not want to insert Dimension then you can just say

='Access Point Link'&'<URL>'&'www.Qlikaccesspoint.com'

And change your expression representation as Link, instead of text.

vishsaggi — Fri, 09 Dec 2016 18:09:35 GMT

Are your AccessPoint links coming from an excel sheet ? I prefer to load from an excel sheet. Name and the Link and use this way

Straight table:

Dim: Name

Expr: = Name & '<url>' & Link

And change the format representation to Link.