Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Scripting languages in QlikVeiw

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.

6 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
tinkerz1
Creator II
Creator II
Author

In the front end user interface, I suspect I need to transform vba code in QV after SQL loads the data.

Gysbert_Wassenaar

Can you explain why you think you need to code functions?


talk is cheap, supply exceeds demand
tinkerz1
Creator II
Creator II
Author

I suspect some of the functions in VBA will be complex math functions.

Not applicable

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.

tinkerz1
Creator II
Creator II
Author

Thanks, there wont be automation tasks being replicated in QV just match functions.

So there is VB script and Javascript?

Are there any others?