topic Re: how to open a PDF when user click on certain value in QlikView

how to open a PDF when user click on certain value

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

In Qlikview, it is possible for a PDF file or image to open up when user select on that certain value?

For example i have 100 values, when user click on value A it will open PDF file A.

Pls see attached sample file. If i click on "Replace supply air sensor" under the Repair Job Types, a PDF file or open.

thanks

Re: how to open a PDF when user click on certain value

Anil_Babu_Samineni — Tue, 04 Apr 2017 05:34:56 GMT

This is the case, You need to work around to produce wither PDF or Image. You need to maintain for each cell in excel and then call that URL like where your PDF path is situated in. Then it will work as you expected. I am assuming you have existing PDF with you so then only it will work for you

Re: how to open a PDF when user click on certain value

devarasu07 — Tue, 04 Apr 2017 05:37:23 GMT

Hi,

Try like

Dimension as hyperlink

Re: how to open a PDF when user click on certain value

tamilarasu — Tue, 04 Apr 2017 05:41:47 GMT

Hi Kok leong ong,

Have a look at the attached file. I just created two sample hyperlinks for testing purpose. You can modify the file as per your need.

Let me know.

Re: how to open a PDF when user click on certain value

Tue, 04 Apr 2017 05:42:42 GMT

How can i do that in Excel and implement it in Qlikview?

Re: how to open a PDF when user click on certain value

Anil_Babu_Samineni — Tue, 04 Apr 2017 05:44:52 GMT

The same way tamilarasu explained to you. Have a look. Here, he used inline we can do with in excel then called up as Hyper links

Re: how to open a PDF when user click on certain value

devarasu07 — Tue, 04 Apr 2017 05:45:24 GMT

Hi,

Please refer to the attached solution. Thanks

Re: how to open a PDF when user click on certain value

Tue, 04 Apr 2017 05:56:13 GMT

Have an error?

Re: how to open a PDF when user click on certain value

tamilarasu — Tue, 04 Apr 2017 06:02:17 GMT

Make sure you don't have any extra space before or after the field name PDF PATH in your excel file.

Re: how to open a PDF when user click on certain value

Tue, 04 Apr 2017 06:06:57 GMT

Hi,

Solved.

But seem cant link

Re: how to open a PDF when user click on certain value

tamilarasu — Tue, 04 Apr 2017 06:14:03 GMT

Try this,

=[Job description] & '<url>' & [PDF path]

=[Job description] & '<url>' & [PDF PATH]

Re: how to open a PDF when user click on certain value

Anil_Babu_Samineni — Tue, 04 Apr 2017 06:15:16 GMT

Seems Case sensitive issue

Re: how to open a PDF when user click on certain value

Tue, 04 Apr 2017 06:17:07 GMT

still cannot.

Re: how to open a PDF when user click on certain value

devarasu07 — Tue, 04 Apr 2017 06:20:40 GMT

below measure column: representation change to Link instead of Text" (by default it will text u have to change manually) for more refer my attached word doc.

=[Job description] & '<url>' & [PDF PATH]

Re: how to open a PDF when user click on certain value

tamilarasu — Tue, 04 Apr 2017 06:27:03 GMT