Hi there everybody
I’m currently trying to do and educated guess if Qlikview is capable to support the functionality we want to deliver to our client in our next project.
The objective is
- Load several files in an Microsoft Access DB
- Validate the data contained in in these several files
- Make some data transformations and calculations and then…
- Visualize the final data in Qlikview.
We mean to develop points from 1 to 3 using a mix between VBA and SQL from MS Access both, but setting the control logic in Qlikview. So, question is:
Is it possible to execute stored-in-an-Access-file VBA functions from Qlikview and catch the return value (to know if the execution run properly)?
Thank you very much in advance. We would appreciate some help to know if Qlikview is our win option.
Regards