topic Re: Scripting languages in QlikVeiw in QlikView

Scripting languages in QlikVeiw

tinkerz1 — Tue, 28 Apr 2015 18:19:21 GMT

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.

Re: Scripting languages in QlikVeiw

Gysbert_Wassenaar — Tue, 28 Apr 2015 18:30:14 GMT

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?

Re: Scripting languages in QlikVeiw

tinkerz1 — Tue, 28 Apr 2015 18:45:51 GMT

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

Gysbert_Wassenaar — Tue, 28 Apr 2015 18:56:25 GMT

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

Re: Scripting languages in QlikVeiw

tinkerz1 — Tue, 28 Apr 2015 19:05:39 GMT

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

Re: Scripting languages in QlikVeiw

Tue, 28 Apr 2015 19:13:13 GMT

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.

Re: Scripting languages in QlikVeiw

tinkerz1 — Tue, 28 Apr 2015 19:16:53 GMT

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

So there is VB script and Javascript?

Are there any others?