topic Re: How to copy a sheet's URL to clipboard with a button object? in QlikView

How to copy a sheet's URL to clipboard with a button object?

Wed, 25 Nov 2020 16:16:04 GMT

I have details of a sheet based on a given value and I want to copy the resulting URL to clipboard, either via script or UI, using a button object.

Example URL which changes based on the highlighted value (in red) the user selects from another sheet:

http://server/abcd/opendoc.htm?document=Dashboard.qvw&select=LB01,20460&sheet=SH04

Re: How to copy a sheet's URL to clipboard with a button object?

vishsaggi — Thu, 04 May 2017 19:14:32 GMT

Can you elaborate a little with some example data? What is that red value where is that value coming from? Where is the URL stored?

Re: How to copy a sheet's URL to clipboard with a button object?

Thu, 04 May 2017 19:29:11 GMT

Hi Vishwarath,

From Sheet 01, for example, we have the following data....

Project Name Project Number Leader Workstream

==========================================

ProjectA 12344 Leader1 WS1

ProjectB 12345 Leader2 WS2

ProjectC 20460 Leader3 WS3

When the user clicks on the Project Number (ie, 20460), a new sheet opens (SH04) with just the details for that project number (Name, Leader, Workstream). That sheet has it's own URL (as indicated in the original post). The user is asking for a way to simply copy that URL to clipboard. I know that they can simply highlight the URL from the browser and copy, but they want a button that can do that.

Thanks for any help!

Re: How to copy a sheet's URL to clipboard with a button object?

vishsaggi — Thu, 04 May 2017 20:07:04 GMT

Read this if this could be of any help?

URL Composer = compute an Access-Point link and pass selection values, open sheets etc.