Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Highlighted
Black_Hole
Contributor

Load and Reload data from Excel to Qlikview

Hello all,

Firstly, I will describe the context.

I would like to load data from Excel in a QV table. 

Moreover, I would like to reload/update data in my QV table if there are modifications in the data from Excel (maybe with a button, I could update data in my QV table).

But, after a lot of research on the web, I still don't know  how I can do that and what is the best way (macro VB, or script, ...) ??

Please could you help with my request.

Thank you in advance for your support.

1 Solution

Accepted Solutions

Re: Load and Reload data from Excel to Qlikview

How would you know that data is updated or not in excel???

Use button in qlikview sheet
right click on button > property > action > trigger > external > reload.

Regards,
Prashant
Great dreamer's dreams never fulfilled, they are always transcended.
7 Replies
Partner
Partner

Re: Load and Reload data from Excel to Qlikview

It is possible to trigger a QlikView task externally with an EDX job. So I assume you can have a macro in excel monitor the excekfile for changes and then trigger the edx job reloading your application.

Please ekskuse my Norglish and Swenglish typos.
Black_Hole
Contributor

Re: Load and Reload data from Excel to Qlikview

Hello @Vegar ,

Great, if EDX job can help me to launch a macro which reload data from Excel to QV. 

Honestly, I never used this functionality of QV.

Please could you share with me some advice, links...  to apply an EDX Job in order load/reload data with a macro.

Thank you in advance for your help.

Partner
Partner

Re: Load and Reload data from Excel to Qlikview

You can use the braathen/qv-edx-trigger (
https://github.com/braathen/qv-edx-trigger ) to trigger from the windows
command prompt/bat script. The readme-file in that project describes
pretty well how to get started.

The bat script you create should be able to run in excel using a macro VBA
script.

BR
Vegar
Please ekskuse my Norglish and Swenglish typos.

Re: Load and Reload data from Excel to Qlikview

How would you know that data is updated or not in excel???

Use button in qlikview sheet
right click on button > property > action > trigger > external > reload.

Regards,
Prashant
Great dreamer's dreams never fulfilled, they are always transcended.
Partner
Partner

Re: Load and Reload data from Excel to Qlikview

@PrashantSangle as I understand it @Black_Hole wants Excel it self to trigger an reload when the excel is updated hence QlikView can not know when an update i done. 

An alternative solution would be to frequently trigger a job in QMC that reads the excelfile change date. When the file date is changed then perform an new load of the file.

Please ekskuse my Norglish and Swenglish typos.
Black_Hole
Contributor

Re: Load and Reload data from Excel to Qlikview

Hello all,

Thank you both of you for your help.

@PrashantSangle :  Great, I tried your solution and it's exactly what I research. It's an easy and quick way to do what I want (and particularly because I'm a novice in QV). 

@Vegar :  Thanks a lot for sharing the link. I will learn how I can do to trigger a job in QMC. 

 

Re: Load and Reload data from Excel to Qlikview

welcome. 🙂
Great dreamer's dreams never fulfilled, they are always transcended.