topic Representing an Expression as a Link in v8.5 in QlikView

Representing an Expression as a Link in v8.5

Fri, 23 Apr 2010 15:28:25 GMT

There is an option in v9.0 that allows the user to set the representation of an expression in a straight table or pivot table to "link", but I do not see this in v8.5.

>Expressions>>Display Options>>>Representation.

I need to figure out a way around this in v8.5.

I need to be able to allow a user to click on a UPS tracking number in Qlikview and have it luanch the UPS website and populate the website with the tracking number they select.

I am trying to due this as a button using the Export/Launch Function and am using this code for the launch command:

wwwapps.ups.com/WebTracking/processInputRequest?tracknum= Tracking_Number

This takes the user to the UPS website but enters "Tracking_Number" into the tracking number input box instead of the actual tracking number the user selected. Tracking_Number is the qlikview field name in my report that contains the actual tracking number.

I know this code works in v9.0:

where 'trackingnumberfieldname' is the name of your field that contains the tracking number and 'TextToDisplayinTable' is what you want the user to see as the clickable text in the table.

HOW DO I GET THIS TO WORK IN v8.5

='TextToDisplayinTable' & '<url>wwwapps.ups.com/WebTracking/processInputRequest?tracknum=' & trackingnumberfieldname

Representing an Expression as a Link in v8.5

johnw — Fri, 23 Apr 2010 22:22:16 GMT

I have clickable links in a couple of 8.5 applications now, so it's probably time I put together an example. Credit to Rob Wunderlich for the idea. I have a Link field and a URL field. The Link field is what I want to display on the screen, and what I put in charts. OnSelect of the Link field, I execute macro OpenURL. That checks to see if 1 and only 1 Link has been selected, and if so, launches the associated URL, and then does a "Back" to undo the selection.

Representing an Expression as a Link in v8.5

Tue, 27 Apr 2010 10:07:25 GMT

Fantastic solution!

I was looking for something similar and the solution is here... I suposse the link field is nothing special, but only a blue and underlined field, isn't it?

Representing an Expression as a Link in v8.5

johnw — Wed, 28 Apr 2010 00:42:25 GMT

Right, it's just a regular old field that I used "custom format cell" to change to blue and underlined. The only other special thing is that selections in that field kick off the macro. But yeah, just a regular field.

Representing an Expression as a Link in v8.5

sparur — Wed, 28 Apr 2010 09:19:19 GMT

Hello, Jonh.

How you manage Custom style for field "Link" in your table box (in your example application which was posted above)

I can't to find any settings for it.

Representing an Expression as a Link in v8.5

johnw — Wed, 28 Apr 2010 16:25:50 GMT

Settings -> User Preferences -> Design -> Always Show Design Menu Items

Right click on cell -> Custom Format Cell -> blue text color and underlined

Representing an Expression as a Link in v8.5

sparur — Thu, 29 Apr 2010 05:33:53 GMT

WOW!

Jonh, thank you.

I didn't knew such feature.

Representing an Expression as a Link in v8.5

johnw — Thu, 29 Apr 2010 17:17:52 GMT

Yeah, I use this feature constantly. I don't know why things like this are hidden by default, or why you can set a document's properties to have Styling Mode = Simplified. I guess QlikTech didn't want to overwhelm everyone with all the options. If I were them, I'd have enabled everything, and not even supported a "simplified" interface that removed half your options. Ah, well.