Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying Links in a straight table

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!

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

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

Sunil Chauhan

View solution in original post

12 Replies
Anonymous
Not applicable
Author

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.

Not applicable
Author

try:

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

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

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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]

Not applicable
Author

Values are still invisible.

Not applicable
Author

did You check:

representation : LINK ?

SunilChauhan
Champion
Champion

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

Sunil Chauhan