Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

URL Links

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

3 Replies
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

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

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


talk is cheap, supply exceeds demand
Not applicable
Author

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!