if then condition in URL

[sspawar88]

Hi Community,

My requirement is to up the link according to the selection of values in id

database table:

id	Entity	URL
1	A	www.google.com
2	B	www.facebook.com
3	C	www.linkedin.com

I have a straight table like following. when I click on id value's it has to up the link on basis of Entity.

Example : when I click on 2 for Entity B it has to up link of www.facebook.com

id	Other Dimension
1	AVC
2	HYT
3	NYP

How I can apply <url> in expression for a different values at a time. ?

[olivierrobin]

hello

you can create an expression like

=id&'<url>& URL

in your graph

[tamilarasu]

Hi Sathish,

Check the below link.

QlikView Dimension Url Links

[sspawar88]

while doing this, even we select representation as "Link" it wont appear as link.

[olivierrobin]

here is what i tried and what it looks like

[sspawar88]

Above links (e.g. www.google.com) are just for example.

my problem here is when I used any field in url and before that I reload it through inline table. it wont give a value. it gives a field name as it is.

[olivierrobin]

for me, if your data is loaded anf fields have the names given,

the formula

=id&'<url>'& URL

should work

could you post a sample application ?