Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

URL in Straight Table not Working

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.

1 Solution

Accepted Solutions
trdandamudi
Honored Contributor II

Re: URL in Straight Table not Working

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

View solution in original post

5 Replies
trdandamudi
Honored Contributor II

Re: URL in Straight Table not Working

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

Not applicable

Re: URL in Straight Table not Working

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
Honored Contributor II

Re: URL in Straight Table not Working

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

View solution in original post

Not applicable

Re: URL in Straight Table not Working

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
Honored Contributor II

Re: URL in Straight Table not Working

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