Drill Through to another website with an URL - Qlik Community

Anonymous · ‎2010-09-30

I am using an action on a button to build an URL based on selected data. Essentially i have a list of "events" and there is an associated event.id. With this id i can launch an url which opens a browser with the detailed data about that event from an OLTP system. Here's my issue. In order for this to work (funtionally), the end user "must" have only one event selected, then he "must" click the button.

Here's what i want to do. I have a table object (i tried with chart-table, pivot tables too) with this event.id in it among other attributes. I would like for the user to be able to simply click on a row of data associated with that id and launch the browser. It would be some sort of row or cell action i guess. Is this possible using QV? I cant find reference to this type of functionalty so I suspect not.

pover · ‎2010-09-30

Tim,

Have you looked in Document Properties -> Triggers and add an action when the event.id field changes or is selected?

Regards.

Anonymous · ‎2010-09-30

Good suggestion...but it didn't work for me. I tried adding an "on select" trigger, then i tried the "on change" and for fun i tried it with both and on select and on change trigger. (triggers were field level triggers on the event.id attribute in question...)

In all cases, selecting (clicking) on the event.id in a table would simply filter the table as you might expect QV to do without any triggers.

My tests were on a table box sheet object. I'll try a few others. Thx for the suggestion tho.

jonathandienst · ‎2010-10-01

Tim

I suggest that you selectively enable the button with the expresssion

=GetSelectedCount(eveentid) = 1

You could also hide the button or change the button text to something like "Select one id" of the selected count <> 1

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

jonathandienst · ‎2010-10-01

Oh, I see that you want this action to happen when you make the selection.

You could do this by creating a link field table. Construct the link using something like:

=eventid & '<url>http://oltpsystem/event.aspx?ev=' & eventid

(DisplayText<url>LinkText) Adjust the link text as needed for your system.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Anonymous · ‎2010-10-01

Thanks for the suggestions Jonathan. I do actually have a button that is only enabled when the count of event.id is 1...for now!

I am going to try your second suggestion too. I'll have a look at link fields. I am guessing they are special fileds that dont try and filter when selected....