topic Re: Hyperlink help please. in QlikView

Hyperlink help please.

Wed, 12 Aug 2015 12:46:36 GMT

I have a dashboard which has a table which displays student information like name,dob,school address.The request is to have a folder for each student when clicked will map to the data base which has a student information document.

ex:

Student name DOB School Document

ABC 123 abc

DEF 456 def

GHI 789 ghi

Here when I click it should MAP to to the database called ProInf which has the information for that particular student.

Can anybody please help me here.

Thanks IN ADVANCE.

Re: Hyperlink help please.

jonathandienst — Wed, 12 Aug 2015 12:49:33 GMT

Not sure what you mean by 'map to the database'. If you want to diplay information on a student, why not load that data into the same model? Or load it into a different QV model and use document chaining.

Re: Hyperlink help please.

Wed, 12 Aug 2015 13:06:40 GMT

That is a word document which has all the information.I mean we want to map to that schools sharepoint site where that documnet is located.

Thehyperlink would be, https://Cobbschools\student\document.

So under that document folder we have the word documnet to all the students.

Re: Hyperlink help please.

jonathandienst — Wed, 12 Aug 2015 14:04:09 GMT

So you mean you want to link to a page on the sharepoint site. I am not sure if you can create a link on an image, but for a normal expression, set the type to Link and enter an expression that returns a string of the format:

displayed text<url>web page

Re: Hyperlink help please.

Qrishna — Wed, 12 Aug 2015 14:31:15 GMT

See attached.

Let me know if thats what you need.

Krishna

Re: Hyperlink help please.

Wed, 12 Aug 2015 17:20:52 GMT

Hi Krishna,can you send the file.I dont see any attached file here

Re: Hyperlink help please.

Qrishna — Wed, 12 Aug 2015 18:13:54 GMT

Open the thread in a new window.

you cannot see attachments in the 'inbox' view i guess..

Anyway find attached.

Re: Hyperlink help please.

Thu, 13 Aug 2015 13:57:22 GMT

Thank you Krishna.

Can you tell me what is the use of first expression which is '=1'

Also,Can i put an image instead of Hyperlink displayed as column value.So,when I click on the image that will open the web page.

Re: Hyperlink help please.

Qrishna — Thu, 13 Aug 2015 15:40:59 GMT

Hi Stacey,

I guess Embedding a picture with a hyperlink in a table is not that simple i guess and we need some kind of extensions for that.

'=1' is for my testing purposes. you can remove that actually.

But as an alternative you try the attached technique.

Also you can try the following link stuff. https://www.qlikcommunity.com/thread/59963

Hope that helps.

Re: Hyperlink help please.

Qrishna — Fri, 14 Aug 2015 20:44:58 GMT

Any Luck on this Stacey?