topic Re: URL in Straight Table not Working in QlikView

URL in Straight Table not Working

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: URL in Straight Table not Working

trdandamudi — Wed, 05 Oct 2016 16:15:41 GMT

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

Re: URL in Straight Table not Working

Thu, 06 Oct 2016 08:51:53 GMT

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'

Re: URL in Straight Table not Working

trdandamudi — Fri, 07 Oct 2016 01:04:29 GMT

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...

Re: URL in Straight Table not Working

Mon, 10 Oct 2016 10:55:57 GMT

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.

Re: URL in Straight Table not Working

trdandamudi — Sat, 15 Oct 2016 15:03:27 GMT

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