topic Re: Opening Word Documents in Qlikview in QlikView

Opening Word Documents in Qlikview

Anonymous — Tue, 01 Sep 2015 15:31:53 GMT

Hi All,

I have some word documents for each Id .

In a Straight Table I am Showing the Id,Name and Document Path as Exression(Link) as below

ID	Name	Path(Representation is Link)
1	Document 1	Path of Document1
2	Document 2	Path of Document2

Application and the Documnets are in same folder.

Now when I click on Path of Document1, Document1 should be opened and if I click on Path of Document2, Document2 must be opened.

Can any one please suggest me how can i achieve it.

Thanks.....

Re: Opening Word Documents in Qlikview

Tue, 01 Sep 2015 16:00:47 GMT

On the expression tab of the chart properties for that table have you tried changing the Representation drop down in the Display Options area from text to link?

Re: Opening Word Documents in Qlikview

Peter_Cammaert — Tue, 01 Sep 2015 16:46:01 GMT

The title of the Path column does confirm that he did.

Re: Opening Word Documents in Qlikview

Tue, 01 Sep 2015 16:48:14 GMT

Whoops somehow missed that, thanks Peter.

Re: Opening Word Documents in Qlikview

Peter_Cammaert — Tue, 01 Sep 2015 16:51:27 GMT

In the Path expression, repeat the Path text value twice and separate them with the text string '<URL>'. For example, if your expression uses field Path, use something like:

=Path & '<URL>' & Path

Keep the Representation set to "Link".

Best,

Peter

Re: Opening Word Documents in Qlikview

Peter_Cammaert — Tue, 01 Sep 2015 16:53:50 GMT

Oh and BTW, everything after the <URL> marker will be treated as part of the actual URL. So don't put anything there that isn't part of the URL. But you can add other stuff to create dynamic links like an Account ID that is available as a Dimension value on the same row...

Peter

Re: Opening Word Documents in Qlikview

Qrishna — Tue, 01 Sep 2015 17:16:34 GMT

See attached.

Hope that helps.