topic Re: if then condition in URL in QlikView

if then condition in URL

sspawar88 — Wed, 27 Jun 2018 07:40:03 GMT

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. ?

Re: if then condition in URL

olivierrobin — Wed, 27 Jun 2018 08:20:50 GMT

hello

you can create an expression like

=id&'<url>& URL

in your graph

Re: if then condition in URL

tamilarasu — Wed, 27 Jun 2018 08:24:15 GMT

Hi Sathish,

Check the below link.

QlikView Dimension Url Links

Re: if then condition in URL

sspawar88 — Wed, 27 Jun 2018 09:49:39 GMT

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

Re: if then condition in URL

olivierrobin — Wed, 27 Jun 2018 09:57:47 GMT

here is what i tried and what it looks like

Re: if then condition in URL

sspawar88 — Wed, 27 Jun 2018 14:09:43 GMT

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.

Re: if then condition in URL

olivierrobin — Wed, 27 Jun 2018 14:14:24 GMT

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 ?