Button to open a file

[naamah]

Hi,

in qlik sense (v. May2021)  I created a button which has a URL to open a file in the server like this: 

'file:/serverName/Folder1/Folder2/Folder3/document.docx'

when i click the button it opens the link in chrome (or same in other web browser)  but omit the colon (:).

when i paste it manuely in the address bar it works good (it downloads the file). or when i add the colon back into the url it also works.

does someone has an idea how to resolve it? why qlik omit the colon?

[brunobertels · Accepted solution]

hi 

not sure but may be try 

'file&chr(58)&/serverName/Folder1/Folder2/Folder3/document.docx'

[naamah]

No, already trief it, still omit the colon 😞

[NellyAcko · Accepted solution]

Hi try %3A instead of chr(58) 

%3A is the default character-set in HTML5 is UTF-8

[pavod]

Hi,

We try the solution with chr(58) or %3A not work in our case, any help ?

Thanks in advance

[NellyAcko]

Hi try this option, it seems from feedback on other forums non-qlik related that you don't need to include the full path when using a server, only the server name and end folder. 

E.G. file://///servername/folder3

So maybe 'file&3A////serverName/Folder3/document.docx' 

[pavod]

Hi

If I put this in the expression : 

='file'&chr(58)&'//DxxxSW/...', the : is omit => file//DI8084SW/QlikShare/...

With ='file&chr(58)&//DxxxSW/...' => file&chr(58)&//DxxxSW/...

With ='file&3A////DxxxSW/...' => file&3a////DxxxSW/...

%3A or 3A are not recognized and chr(58) not work or omit

[NellyAcko]

Ah looks like all options here are ruled out. Ill try and do a test myself and and will let you know the outcome ASAP.

[NellyAcko]

Hi I have just realised you have used &3A and not %3A that was my typo, sorry please try

 'file%3A////serverName/Folder3/document.docx' 

[pavod]

Don't worry, if I put the same expression, nothing happens when I click on the button

='file%3A////DxxxSW/...'