topic Re: Link in QlikView

Link

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All i have striagth table with many columns , and the first column is ID , and there are many id's , and every id a=has a link , when we click on any id it will take us to the related information to another table.

can someone tell me how do we do this ?

this is the screen whot of that table , look here in the first column all the id's are in blue colour and has the link to another page.

Or i can say that the first fiel which is ID is clickable for each ID and it will navigate to two other charts once clicked on any of the ID, by hiding the current stratit table.

Can someone tell me how do we achieve this ?

thanks in advance .

Re: Link

devarasu07 — Thu, 16 Mar 2017 03:39:24 GMT

Hi John,

Can you share the expected output (after navigated to new table link) and mock app with sample data. Thanks

meanwhile check this,

Making QlikView Part of the Story: Embedding Objects into Web Pages

iFrame Integration Example

Hope this helps you

Regards,

Deva

Re: Link

smilingjohn — Thu, 16 Mar 2017 04:55:18 GMT

Hi Devarasu,

When i click on any of the ID , then it will hide the current start tale and in the same place two differnt tables will be displayed with related information to that erticular ID .

I dont understand how they have done it .

Re: Link

neha_shirsath — Thu, 16 Mar 2017 05:41:56 GMT

Hi John,

Understanding your question-

Means if you have 10 number of columns in your straight table and if user select any field data from column then this chart should be hide and other 2 chart will display is this your requirement?

Thanks,

Neha

Re: Link

smilingjohn — Thu, 16 Mar 2017 05:53:03 GMT

Hi Neha,

ok let me explain you .

I have astraight Table which has N number of columns ,and the first column (Field) name is Cutomer ID and when i clik on any of the customer ID it is taking me to another table with related information of that ID , by hiding the Startight table.

I hope iam clear now

Re: Link

rahulpawarb — Thu, 16 Mar 2017 06:08:53 GMT

Hello John,

Considering that you are using QlikView, below are the steps to implement Hyperlink functionality:

1. Add required dimensions

2. Add below expression

= [Cutomer ID] & '<url>http://www.google.com' // I took sample link as www.google.com

3. Set the Representation to Link available under Display Option

4. Define the Text Color of the same expression to Blue()

Hope this will help.

Regards!

Rahul

Re: Link

neha_shirsath — Thu, 16 Mar 2017 06:46:55 GMT

Hi John,

Please find the attached test file.

Hope it will help you.

Thanks,

Neha

Re: Link

neha_shirsath — Thu, 16 Mar 2017 06:50:50 GMT

Find the corrected file here.

Here,Country field will perform like your first ID field.

Thanks,

Neha

Re: Link

smilingjohn — Thu, 16 Mar 2017 06:52:16 GMT

Hi Neha i dont underand what have you done ?

This not my requirement

Re: Link

smilingjohn — Thu, 16 Mar 2017 06:57:16 GMT

Hi Rahul ,

What u said i agree to it.

But i dont need to create any link to url .

look this is what my issue is

let me explain you .

I hope iam clear now

and if you look into the image below , all the ID's are in blue and i checked into the expression there is nothing mentioned like link .but still this Field is acting as a link to other charts .

Re: Link

neha_shirsath — Thu, 16 Mar 2017 06:57:49 GMT

Can you post your sample data?

Re: Link

Anil_Babu_Samineni — Thu, 16 Mar 2017 07:17:49 GMT

Then remove the <URL> tag of your field called. Or else you may create sample and then explain

Re: Link

rahulpawarb — Thu, 16 Mar 2017 07:31:25 GMT

Hello John,

Thank you for sharing your valuable inputs.

Could you please share the application with sample data? This will help us to understand the issue and remove the unwanted hyperlink from straight table.

Regards!

Rahul