Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
siddheshmane
Creator
Creator

Script Editor

Hi,

Is it possible to use VB scripting in the script editor. By scripting I mean the whole code in the script editor. Basically like the way we code for a VB application. I'm a regular VB and C# coder, so I thought this might be a simpler way to start developing in Qview.

Thanks.

2 Replies
marcus_sommer

Yes, it's generally possible by creating functions within the vbscript and using per a normal function-call like:

function(parameter)

but many functionalities from qv-api aren't available while the reload then they need an ActiveDocument which didn't exists before the reload is finish. In my opinion you should rather avoid such doing and only use if there are no other way which will be quite rarely. Then nearly everything on control-structures like sub, if-then-else, variables, include-variables ... are inbuilt qv-script features.

- Marcus

jonathandienst
Partner - Champion III
Partner - Champion III

Its not possible to create the reload script in VB or C#. This can only be done using QV script language. As Marcus said, most api calls used by vbscript or a .Net language like C# require an ActiveDocument object which is only available when the reload is complete. Only the QV script can load data into memory.

It is possible to call vbscript functions in your load script to make use of features in vbscript not available to QV script, such as regular expressions. These functions cannot include most QV api calls, however, for the reason explained earlier.

It is also possible to use automation to start the reload using api calls. This starts the execution of the QV script.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein