topic Re: Dynamically create buttons to website address in QlikView

Dynamically create buttons to website address

Thu, 22 Jan 2015 22:29:02 GMT

Hey Community,

So pretty much like the title says, I have a straight table where the data is a web address with some metrics about it. I thought it would be a really, really cool feature, that if next to each web address there was a button that could be pressed so the user could go out and see what page the web address is referencing. Is there script to dynamically create such buttons based on what data is in the page path? Ideally, it would be part of the table. Any thoughts? Let me know if you need more information!

Thank You!

Re: Dynamically create buttons to website address

marcus_sommer — Thu, 22 Jan 2015 22:39:14 GMT

You need only turn the expression-interpretation from text to link and you could call these websites.

- Marcus

Re: Dynamically create buttons to website address

Thu, 22 Jan 2015 22:42:13 GMT

Well the thing is that the web adderss in the straight table shows only the page path, not the hostname (should have mentioned that above, my apologies). To conserve space, if you have www.hostname.com/pagepath. It only shows the pagepath. So the buttons would need to concatenate the hostname at the beginning.

Re: Dynamically create buttons to website address

marcus_sommer — Thu, 22 Jan 2015 22:48:34 GMT

You could use: = 'ShortLink<url>' & field/expression with full-linkpath

- Marcus

Re: Dynamically create buttons to website address

Thu, 22 Jan 2015 22:51:36 GMT

The pagepath is a dimension though....

Am I missing something? I think you can only interrupt the expression as a link.

Re: Dynamically create buttons to website address

marcus_sommer — Thu, 22 Jan 2015 23:02:12 GMT

If pagepath a valid link in a field you could use:

'ShortLink<url>' & only(pagepath)

- Marcus