URL in Straight Table not Working

[#1]

Hi Guys

I have set links in my spreadsheet in the following format and QV is not recognising the link even after changing representation to Link.

Could  you please have a look at my expression and let me know if it wrong.

'Cardiovascular Disease: Risk Assessment And Reduction, Including Lipid Modification'&'<URL>'&'https://www.nice.org.uk/guidance/cg181'

many thanks

Greg M.

[trdandamudi]

See if the attached will work for you.....

[#3]

Thank you very much for getting back to me so quickly. How do I repeat this for several links like below?

IS MY LINK EXPRESSION CORRECT?

I have attached example table below:

Actions to ensure implementation (completed and outstanding)	Title and Link
Completed	'Cardiovascular Disease: Risk Assessment And Reduction, Including Lipid Modification'&'<URL>'&'https://www.nice.org.uk/guidance/cg181'
Outstanding	'Multimorbidity: Clinical Assessment And Management'&'<URL>'&'https://www.nice.org.uk/guidance/ng56'
Completed	'Dementia: Supporting People With Dementia And Their Carers In Health And Social Care'&'<URL>'&'https://www.nice.org.uk/guidance/cg42'
Outstanding	'Mental Health Problems In People With Learning Disabilities: Prevention, Assessment And Management'&'<URL>'&'https://www.nice.org.uk/guidance/ng54'
Completed	'Stable Angina: Management'&'<URL>'&'https://www.nice.org.uk/guidance/cg126'
Outstanding	'Acute Upper Gastrointestinal Bleeding In Over 16S: Management'&'<URL>'&'https://www.nice.org.uk/guidance/cg141'
Completed	'Heavy Menstrual Bleeding: Assessment And Management'&'<URL>'&'https://www.nice.org.uk/guidance/cg44'
Outstanding	'Autism Spectrum Disorder In Adults: Diagnosis And Management'&'<URL>'&'https://www.nice.org.uk/guidance/cg142'

[trdandamudi · Accepted solution]

I took the first three records from your table and loaded into qlikview, So please take a look at the script in the attached file for the solution. Hope this helps...

[#5]

Thank you very much I also just loaded the actual table with the Title and Link data( i.e. Links I wanted to navigate to on clicking) in the following format and it worked Cardiovascular Disease: Risk Assessment And Reduction, Including Lipid Modification <URL> https://www.nice.org.uk/guidance/cg181

The ' was not needed.

[trdandamudi]

Happy to hear that it worked. I was away from last one week and I just saw your message....