topic Open selected path when clicking a button in QlikView

Open selected path when clicking a button

Wed, 21 Dec 2011 13:15:13 GMT

Hi,

have a table with 3 columns x, y and z. In column z is the path of a file.

I want to create a button which copy the path from a selected value in column x to the clipboard an opens the path in the explorer.

Could anyone help?

Re: Open selected path when clicking a button

sbaldwin — Wed, 21 Dec 2011 14:31:11 GMT

Hi, you couly use the only function and the lauch external application action on a button to open the folder andthen add an action that runs a macro something like this:

ActiveDocument.GetSheetObject("BU01").CopyTextToClipboard

where BU01 has the text =only(your_field_containing_path)

i've attached an eg.

Thanks

Steve

Sub mycopy
ActiveDocument.GetSheetObject("BU01").CopyTextToClipboard

end Sub

Re: Open selected path when clicking a button

brenner_martina — Wed, 21 Dec 2011 14:54:31 GMT

Hi, Charlie,

there is an integrated action in Qlikview, to open files, see attached example.

Greetings from Munich

Martina

EVACO GmbH

Re: Open selected path when clicking a button

Wed, 21 Dec 2011 15:12:03 GMT

Thanks a lot!

Both ways are working 🙂