topic Re: Button to open a file in App Development

Button to open a file

naamah — Fri, 15 Nov 2024 21:05:29 GMT

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?

Re: Button to open a file

brunobertels — Wed, 31 Jan 2024 17:45:30 GMT

not sure but may be try

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

Re: Button to open a file

naamah — Thu, 01 Feb 2024 08:19:30 GMT

No, already trief it, still omit the colon 😞

Re: Button to open a file

NellyAcko — Sun, 04 Feb 2024 00:36:51 GMT

Hi try %3A instead of chr(58)

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

Re: Button to open a file

pavod — Thu, 06 Jun 2024 08:42:58 GMT

Hi,

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

Thanks in advance

Re: Button to open a file

NellyAcko — Thu, 06 Jun 2024 08:55:52 GMT

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'

Re: Button to open a file

pavod — Thu, 06 Jun 2024 09:10:32 GMT

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

Re: Button to open a file

NellyAcko — Thu, 06 Jun 2024 09:18:15 GMT

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.

Re: Button to open a file

NellyAcko — Thu, 06 Jun 2024 09:31:09 GMT

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'

Re: Button to open a file

pavod — Thu, 06 Jun 2024 10:07:22 GMT

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

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