Sometimes you will be required to add links to redirect users to the original source of data. This usually happens when you are analyzing help desk information, and you need to check the original ticket. Instead of moving to your help desk system and look for the ticket, you can add a link in QlikView that redirects you to the one that you need to verify. In this quick tip, we will show you how to add links in a straight table. Current example has been applied to redirect users to posts in this blog, but the same approach can be used in other scenarios.
Let's start by creating a straight table. Once you have selected your dimensions, move to Expressions tab and in Display Options, select Link.
Next, add an expression with the following structure:
=DisplayText& '<url>' & Link
DisplayText is the string to be displayed in your straight table, and link is the full url to be opened in your browser. In this example, we want to display the text "Go to Post" in the cell. The link is built
concatenating variable that contains the url of this blog with the valu in Post ID field.
When you're done, the field with the link expression will look the following.
When you hit one of your links, your browser will be open and the selected url will be loaded.
You can download this example from here.
No comments:
Post a Comment