Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
chauhans85
Esteemed Contributor

Re: Displaying Links in a straight table

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

12 Replies
dennisnet
Valued Contributor III

Re: Displaying Links in a straight table

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

Re: Displaying Links in a straight table

try:

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

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

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

Not applicable

Re: Displaying Links in a straight table

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

Not applicable

Re: Displaying Links in a straight table

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

Not applicable

Re: Displaying Links in a straight table

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

Re: Displaying Links in a straight table

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

Re: Displaying Links in a straight table

Values are still invisible.

Not applicable

Re: Displaying Links in a straight table

did You check:

representation : LINK ?

chauhans85
Esteemed Contributor

Re: Displaying Links in a straight table

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

Community Browser