topic Re: Regarding Excel upload in QlikView

Regarding Excel upload

Tue, 15 Jul 2014 17:46:31 GMT

Hello Friends,

Is there any way to upload an excel file on a fly using a macro in a desktop application with out publisher?

Thanks,

Kiru

Re: Regarding Excel upload

Anonymous — Tue, 15 Jul 2014 17:56:01 GMT

Certainly using Reload action of Button.You can create xls name in variable based on dynamics of xl file name

Re: Regarding Excel upload

Tue, 15 Jul 2014 18:02:34 GMT

Thanks Swapnil !

Kindly could you explain a little in detail or share an example if you already have one?

In reload button action ,I am able to reload only the existing application.

Thanks so much

Kiru

Re: Regarding Excel upload

Anonymous — Tue, 15 Jul 2014 18:05:55 GMT

Kiru, Can you explain a bit what exactly you are trying to achieve?What does on the fly mean exactly what is your use case?

Re: Regarding Excel upload

shree909 — Tue, 15 Jul 2014 18:09:49 GMT

Hi,

I think u need to create an action on the button or textbox and when u hit the button it will reload the application.

or create an if statement when to reload the button depending on the time.

Thanks

Re: Regarding Excel upload

Tue, 15 Jul 2014 18:17:13 GMT

Dear Swapnil,

Thanks so much!

My scenario:

I have an application which is fetching data from 2 excel files.

Now, In the same application , the user wants to upload new excel files by them selves when ever needed by clicking a button in user interface instead in edit script.

Say for eg, I have attached an application which fetches data from excel,kindly let me know that I can update that source with the new source by clicking a botton in front end and charts changes according after reload with new source?

Kindly let me know if you did not get it!

Thanks,

Kiru

Re: Regarding Excel upload

Tue, 15 Jul 2014 18:24:56 GMT

Hello Shree,

Thanks so much!

I need to upload a file before reload,kindly let me know is there any way to upload an excel file by clicking a button instead of using through edit script because the user is unfamiliar with the QlikView?

What I am looking is just by clicking a button in user interface,it navigates to a folder ,I can then select and upload the excel file into QlikView!

so then I can create a button for reload as you suggested!

Please let me know

Thanks,

Kiru

Re: Regarding Excel upload

Anonymous — Tue, 15 Jul 2014 18:27:59 GMT

I think of this which will work on desktop client

Step 1: Create a input box for file name (user will input file name)

Step 2: Populate variable with value in input box

Step 3: Have your script as below

Load

From

Step 4:Create button and set action to reload

If path is going to change always user need to give file name along with complete path. If path is same you can hardcode path and take file name from input box

Re: Regarding Excel upload

Tue, 15 Jul 2014 18:53:30 GMT

Awesome!

Thanks so much for your timely help and I really appreciate it

Regards,

Kiru