topic Re: Opening url using list box in QlikView

Opening url using list box

miranrai — Thu, 14 May 2015 09:31:31 GMT

I have requirement to open url when particular value in list box is selected.

List box has following values.

URL http://localhost/QvAJAXZfc/opendoc.htm?document=Examples%2FDemo.qvw&host=QVS%40vcengstrptappd1 should open when V4 value is selected from list box.

Is there any work around for this?

Re: Opening url using list box

Gysbert_Wassenaar — Thu, 14 May 2015 15:59:16 GMT

Use a straight table with an expression with representation type Link. The kind of expression you need looks like:

='V4<URL>http://‌localhost/QvAJAXZfc/opendoc.htm?document=Examples%2FDemo.qvw&host=QVS%40vcengstrptappd

Re: Opening url using list box

petter — Thu, 14 May 2015 16:10:27 GMT

It can easily be achieved with a straight table where you have just two columns - one expression and one dimension column that you could hide.

You will have to have a table with two fields named Text and Links (or whatever you prefer to call them).

Create the straight table add the text for the link as dimension and as an expression you add:

=Text & '<URL>' & Links

Then select No Totals in Total Mode on the Expression tab (look at screenshot)

Then select for Representation under Display Options: Link ... also on the Expression tab (look at screenshot)

Re: Opening url using list box

miranrai — Fri, 15 May 2015 06:23:45 GMT

Using Link from expression will make all the values in straight table as link. I want only V4 value to be hyper linked and not all. And this straight table should look like list box (value getting highlighted when selected.).

Re: Opening url using list box

jonathandienst — Fri, 15 May 2015 06:51:45 GMT

You can make the url expression conditional, building on the above suggestions, like

=Only({1} If(dimension = 'V4', ...... url expression as defined above.....))

(to display the expression for V4 and hide the others. Only() ensures that row is displayed when a selection is made)

=only({1} If(dimension = 'V4', ...... url expression as defined above....., ....normal expression))

(only the valid url expressions will hyperlink)

To colour highlight an expression, based on the selection of the dimension, you will need to add a foreground colour expression to the expression. Click + next to the expression to access the foreground colour setting.

Re: Opening url using list box

miranrai — Mon, 18 May 2015 06:08:37 GMT

Thanks everyone.