URL Links

[#1]

Hi -

I need help with writting an expression that will display links based on the data sources.

In my initial query I used the following trick to display data from Table1.

Can you please help me merge two tables into a single field?

Table 1: issue&'<URL>www.qlik.com&[issue]

Table 2:issue&'<URL>www.google.com&[issue]

Thank you

[#2]

I just realized that i was not providing you with an accurate set of data.

In simple words here is what i am trying to do:

IF( 'Issue' = (first 3 letters ABC- display URL 'www.qlik.com') else display url www.google.com)

Is this possible to achieve in Qliview?

Thank you!

[Gysbert_Wassenaar]

If(left(Issue,3)='ABC',

     'www.qlik.com<URL>www.qlik.com',

     'www.google.com<URL>www.google.com')

[#4]

I tired your suggestion and when i clicked on the lin, QV did not recognize the 'ABC' command. It takes me straight to www.google.com.

I also tried the following with no success:

if(left(Issue,3)='ABC',

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

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

Please help!