topic Re: Displaying Links in a straight table in QlikView

Displaying Links in a straight table

Tue, 12 Feb 2013 13:28:29 GMT

Hi -

I am working with a straight table where I am re-directing my users to access different web pages based on a condition (if issue starts with certain letters go to one page, else go to another).

Links are working properly, but for some reason values for URLs are not visable in my table. Any suggestions on what i should do?

I chcked every single property that there is and did not see anything that would cause this to happen.

Here is my expression:

if(left([issue],3)='ABC',

('<URL>www.google.com'&[issue]),

'<URL>www.yahoo.com'&[issue])

Thank you!

Re: Displaying Links in a straight table

Anonymous — Tue, 12 Feb 2013 13:36:44 GMT

I dont see anything wrong in your expression.

Could it be that your dimension does not return a distinct result?

Is [issue] also the dimension you use?

What happens when you narrow your selection to the smallest data possible, does it show then?

Dennis.

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:40:42 GMT

try:

if(left([issue],3)='ABC',

'google''<URL>www.google.com'&[issue],

'yahoo''<URL>www.yahoo.com'&[issue])

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:46:50 GMT

That did not work also i need to display individual links. Any other suggestions?

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:47:09 GMT

No that does not work, anything else i can do?

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:51:13 GMT

what Youe mean "not work"

is it still invisible?

try:

if(left(only([issue]),3)='ABC',

'google''<URL>www.google.com'&only([issue]),

'yahoo''<URL>www.yahoo.com'&only([issue]))

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:52:17 GMT

Also I was thinking of creating another column where I would concatenate URL with ISSUE number which would serve as a link. This option worked for me in the past with a single URL address, but it does not seem to like multiple sites.

Here is my attemp at this:
Example 1. issue&'<URL>[URL]'&[issue]

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:53:23 GMT

Values are still invisible.

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 13:58:25 GMT

did You check:

representation : LINK ?

Re: Displaying Links in a straight table

SunilChauhan — Tue, 12 Feb 2013 14:09:56 GMT

Try this and

if(left([issue],3)='ABC',

[issue]&'<URL>'&'www.google.com',

[issue]&'<URL>'&'www.yahoo.com')

Try this and

if(left([issue],3)='ABC',

'www.google.com'&'<URL>'&'www.google.com',

'www.Yahoo.com'&'<URL>'&'www.yahoo.com')

Re: Displaying Links in a straight table

SunilChauhan — Tue, 12 Feb 2013 14:12:02 GMT

see the attched file

Re: Displaying Links in a straight table

Tue, 12 Feb 2013 16:08:21 GMT

This is what worked for me :-)! thank you for your help

if(left([issue],3)='ABC',

[issue]&'<URL>'&'www.google.com'&[issue],

[issue]&'<URL>'&'www.yahoo.com'&[issue])

Re: Displaying Links in a straight table

geetha_n — Fri, 07 Dec 2018 11:50:33 GMT

Is there any method to link another sheet...!