topic Re: URL Links in QlikView

URL Links

Mon, 11 Feb 2013 14:08:55 GMT

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

Mon, 11 Feb 2013 14:33:54 GMT

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 — Mon, 11 Feb 2013 14:38:53 GMT

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

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

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

Mon, 11 Feb 2013 14:49:50 GMT

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!