Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been given a task to take some excel spreadsheets and their vba functionality into qlikview.
Can I script in VBA, VB.NET or C# as there are some heavy functions to deploy.
If not whats the best way to do this?
Thanks,
Neil.
You can use javascript and vbscript for coding macro's. But do keep in mind that Qlikview is NOT a spreadsheet application. Trying to use it as one will be painful. And macro's should be avoided as much as possible imo. Where do you need these 'heavy functions'? In the script to load the data or in the front end user interface?
In the front end user interface, I suspect I need to transform vba code in QV after SQL loads the data.
Can you explain why you think you need to code functions?
I suspect some of the functions in VBA will be complex math functions.
Qlikview will also perform powerful calculations, First you need to design your VBA script functionality and adopt those design into qlikview either in script level or Front end based on your data model.
Thanks, there wont be automation tasks being replicated in QV just match functions.
So there is VB script and Javascript?
Are there any others?