Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
See if the attached will work for you.....
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' |
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...
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.
Happy to hear that it worked. I was away from last one week and I just saw your message....