topic How to browse a folder and get file using external macro in qlikview? in QlikView

How to browse a folder and get file using external macro in qlikview?

Siva_Sankar — Wed, 06 Jun 2012 09:15:26 GMT

Hi. my requirement is i need a button that should show the list of files while clikcing, and load the selected file into qlikview using another button. can u help?

How to browse a folder and get file using external macro in qlikview?

Wed, 06 Jun 2012 12:19:42 GMT

For getting a list of files, you can use the filelist() function.

How to browse a folder and get file using external macro in qlikview?

Miguel_Angel_Baeyens — Wed, 06 Jun 2012 13:07:42 GMT

Hi,

Check the code in this post and this post among some others, with macro to browse a folder and load some files following date criteria.

Hope that helps with a little tweaking.

Miguel

How to browse a folder and get file using external macro in qlikview?

Siva_Sankar — Thu, 07 Jun 2012 04:33:57 GMT

Miguel, Thanks for the help. I brought the functionality to list and show the files in listbox inside qlikview. I dont need to load the file according to date criterial I want to select the qvw file that is showwing in the listbox and reload the qvw file(which is selected in the list box) using the button(macro enabled may be). Can you help? Regards, Sivasankar

Re: How to browse a folder and get file using external macro in qlikview?

Siva_Sankar — Wed, 20 Jun 2012 08:50:57 GMT

Finally, I achieved it. Attached the file for the one who needs in future.

Re: How to browse a folder and get file using external macro in qlikview?

carolinnolte — Mon, 29 Apr 2013 09:43:23 GMT

Hi,

are there any Issues regarding Win XP and IE8?

If I use the example fileDynamic File Reloadforforum.qvw it somehow fails when I close the file dialog with the ok button. Unfortunatly the error message just tells me that the macro has no functionality.

The error occurs on Desktop as well on Access Point. I'm using QlikView 11.00.11414.0 SR2

I there anything I can do to get this working?

Re: How to browse a folder and get file using external macro in qlikview?

sunny_talwar — Mon, 23 Mar 2015 13:23:39 GMT

Hi Siva,

I am looking for a similar functionality where the users can browse for the file name instead of copy pasting its path. I opened up your QVW file (allowing the safe macro). When I click on the Browse Button it takes me to Edit Module window instead of letting me browse. Do I need to change anything in the macro to make it to work?

Best,

Re: How to browse a folder and get file using external macro in qlikview?

Siva_Sankar — Mon, 23 Mar 2015 13:53:41 GMT

Hi,

In the edit module, bottom left, click the drop down button and select 'Allow System Access' and click OK.

Refer attached screenshot.

Regards,

Siva

Re: How to browse a folder and get file using external macro in qlikview?

sunny_talwar — Mon, 23 Mar 2015 14:08:35 GMT

Thanks for your response Siva.

This actually worked for me now. The only question I have is, will this functionality work on a server downloaded copy? You may or may not know if it will (and I am in process of getting it tested), but I just wonder if you do have an idea about this.

Best,

Re: How to browse a folder and get file using external macro in qlikview?

Siva_Sankar — Mon, 23 Mar 2015 14:25:51 GMT

Hi,

I haven't tested. You may try and let us know the outcome.

Regards,

Siva

Re: How to browse a folder and get file using external macro in qlikview?

sunny_talwar — Mon, 23 Mar 2015 14:37:37 GMT

I definitely will. I might not know for next few days, but will let everyone know as soon as I have something

Best,

Sunny