Displaying Links in a straight table

[#1]

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!

[Anonymous]

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.

[#3]

try:

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

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

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

[#4]

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

[#5]

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

[#6]

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]))

[#7]

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]

[#8]

Values are still invisible.

[#9]

did You check:

representation : LINK ?

[SunilChauhan · Accepted solution]

Try this and

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

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

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

or

Try this and

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

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

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