topic Re: Opening related URL in table box sheet object in QlikView

Opening related URL in table box sheet object

Tue, 26 Mar 2013 09:19:16 GMT

Hi,

Is it possible to open related url from a Table Box Object?

For example:

Id	First Name	Last Name
1	Joe	Johnson
2	Kobe	Bryant
3	Dwight	Howard
4	Tim	Duncan
4	Jason	Terry

If for example I click on "Kobe Bryant", Instead of the default behavior that will show on "Kobe Bryant Row". I want to run an action that opens related url (somewhere like: http://someurl.com?Id=2).

Is it achievable? How to do it? Thanks..

Re: Opening related URL in table box sheet object

kaushiknsolanki — Tue, 26 Mar 2013 09:27:46 GMT

Hi,

Its not possible with Table Box, but you can achieve this using the Straight Table.

In Expression tab use representation as Link. And use the <URL> in expression.

Regards,

Kaushik Solanki

Re: Opening related URL in table box sheet object

Tue, 26 Mar 2013 09:51:05 GMT

Do you mean straight table in "Chart Object"?

How to use representation as link in Expression Tab? Thanks..

Re: Opening related URL in table box sheet object

kaushiknsolanki — Tue, 26 Mar 2013 10:04:32 GMT

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki

Re: Opening related URL in table box sheet object

Wed, 27 Mar 2013 02:37:25 GMT

Hi Kaushik,

I've tried using the approach that you've sent me, but the straight table gives me: "No Data To Display".

Here is what I do, I have a table that have fields: Name & Address

I make a "chart" sheet object with "straight table" type.

I put the Name in Dimension

and in the expression I put Name & '<url>' & Address

Am I missing anything? Thanks

(Attached is the file)

Re: Opening related URL in table box sheet object

kaushiknsolanki — Wed, 27 Mar 2013 05:12:33 GMT

Hi,

In your attachment you have selected chart type as Bar, so change it to Straight table and it works.

Regards,

Kaushik Solanki

Re: Opening related URL in table box sheet object

kaushiknsolanki — Wed, 27 Mar 2013 05:34:17 GMT

Hi,

Also noticed that the address is not in proper form.

Meaning you have written address as http://google.com but it should be http://www.google.com

Regards,

Kaushik Solanki

Re: Opening related URL in table box sheet object

Wed, 27 Mar 2013 06:26:02 GMT

Hi,

Already follow your directions, but still can't make it to work, is there anything that I miss? Thanks

Re: Opening related URL in table box sheet object

kaushiknsolanki — Wed, 27 Mar 2013 07:13:13 GMT

Hi,

Yes you missed one setting.

You didnt select Link from Representation in expression tab.

Also noticed one more thing that Martin have two Address associated with it, so at first go only Robbie will work but when you select the Martin and Product as Shorts, the link will work.

Regards,

Kaushik Solanki

Re: Opening related URL in table box sheet object

Wed, 27 Mar 2013 07:34:09 GMT

Hi Kaushik,

Thanks now It works and I understand properly