topic field linkable in QlikView

field linkable

Tue, 06 Apr 2010 09:41:09 GMT

Hello at All,

in a field I have a list of url. For example www.mysite.com .

I need to know i if is possible to link the url and to go in the web page I selected.

Does QV support <a> tag? (jtml),

Thanks in advance.

Slash

field linkable

sparur — Tue, 06 Apr 2010 09:48:09 GMT

Hi, Slash.

In Qlikview 9.0 you can achieve this.

see the standard example file "What's new in QV9" and go to the last tab "Exchange Rates". And you will see a solution.

field linkable

Tue, 06 Apr 2010 09:57:21 GMT

I develop by 8.5 release. Please, does exist other solution?

Slash

field linkable

sparur — Tue, 06 Apr 2010 10:22:05 GMT

May be try to use a button with type Launch/Export and setup this button to open your link? do you tried it?

field linkable

Tue, 06 Apr 2010 10:39:36 GMT

INo I don't. I Does QV support <a> tag?

field linkable

sparur — Tue, 06 Apr 2010 10:59:20 GMT

No, as I know, QV doesn't support any html tag.

field linkable

sparur — Tue, 06 Apr 2010 11:00:21 GMT

try to use a button object for creating a "link" button

field linkable

Tue, 06 Apr 2010 12:25:22 GMT

Do not exists link button object and do not exists the option "link button" ...

field linkable

Tue, 06 Apr 2010 13:14:38 GMT

YOu can achieve this by using macros. Just try the open URL predefined Macro in QlikView. This should help.

field linkable

vupen — Tue, 06 Apr 2010 13:44:47 GMT

Please see the attached sample QV document. It does provide such a 'navigate' feature, though with a click again, using the INFO feature.

Upendra

field linkable

Tue, 06 Apr 2010 13:45:28 GMT

hi splash,

i have attached a screen shot of one of my application in which i have created a field "url" and i have displayed the list of url's in a list box.

now when you select a particular url in the listbox "url" and then click on the button "go to" ,then that particular webpage will open.

i have included two actions in the button

first , select in field url and the search string is =url

second action is, open url =url

i think this should work fine

thanks

field linkable

Tue, 06 Apr 2010 13:57:37 GMT

hi ,

i have attached my application also to illustrate this

pls check it .

field linkable

Tue, 06 Apr 2010 14:22:40 GMT

thanks but it doesn't work.

I try by 8.5 release..

field linkable

Tue, 06 Apr 2010 14:40:37 GMT

hi,

then pls download the qlikview 9 personal edition from qlik.com

thanks

field linkable

Tue, 06 Apr 2010 14:56:41 GMT

🙂

My company policy not permitted to update to a new release .

Thank

Regards,

Slash

field linkable

johnw — Wed, 07 Apr 2010 01:50:25 GMT

Rob Wunderlich suggested an approach that's working just great in a couple of my 8.5 applications.

I create two fields, a "Link" field, and a "URL" field. The link is what I want to display on the screen, and the URL is the associated URL. Not sure why I called the field "Link". Call it whatever you want. To make it user friendly, these links are in charts with the cells custom formatted to display the Link value underlined and blue. I trigger a macro onSelect of the Link field:

sub OpenURL
if ActiveDocument.Fields("Link").getSelectedValues.Count = 1 then
ActiveDocument.GetApplication.Launch ActiveDocument.Evaluate("URL"),""
ActiveDocument.Back 'Go back so we don't do the selection
end if
end sub

field linkable

Thu, 09 Dec 2010 16:36:32 GMT

this works but only sporadically...i've tried this syntax with a variety of links

some launch (notepad.exe as an absurd example or some hlp files)

but it seems others will not.

i've set the security options properly in User Preferences,

but i can't seem to get consistent results.

and on a related note, the Field Event Trigger => External => Launch => (file.exe) doesn't work at all.

if this sort of 'click and launch from cell' concept is problematic, so be it

most appreciative of any insight

marc

Re: field linkable

Thu, 21 Nov 2013 10:56:06 GMT

Hi John,

I used your macro code to open the link on field selection, but when i access this application on "Access Point with Full Browser Version" it is not working but it is working for "Access Point with IE Plugin".

Can you please let me know same functionality should work on "Full Browser Version" also.

Please let me know if it possible?

sub OpenURL

if ActiveDocument.Fields("Link").getSelectedValues.Count = 1 then

ActiveDocument.GetApplication.Launch ActiveDocument.Evaluate("URL"),""

ActiveDocument.Back 'Go back so we don't do the selection

end if

end sub