Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
tinkerz1
Contributor 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

Re: Scripting languages in QlikVeiw

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
Contributor II

Re: Scripting languages in QlikVeiw

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

Re: Scripting languages in QlikVeiw

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


talk is cheap, supply exceeds demand
tinkerz1
Contributor II

Re: Scripting languages in QlikVeiw

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

Not applicable

Re: Scripting languages in QlikVeiw

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
Contributor II

Re: Scripting languages in QlikVeiw

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

So there is VB script and Javascript?

Are there any others?

Community Browser