Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Scripting language in qlikvew

As far as I understand, the following is a comment in qlikview

 //This is a comment

'This is not a comment

Whats going on. I see a lot of VB script comments for qlikview on the net like https://denvercoder9.wordpress.com/2012/02/29/qlikview-vb-scripting-for-newbies/

or here

http://community.qlik.com/thread/14503

Can some one please enlighten me? I simply created a qlikview file and pressed Ctrl + E to pull up the scripting window. Is there a default setting to set the language here? What am I missing?

like image 690
VivekDev Avatar asked Jan 29 '15 12:01

VivekDev


2 Answers

There are two types of scripts in QlikView: "Load" scripts and "Module" scripts.

A document's Load Script is executed when you perform a reload (Ctrl+R), and are responsible for obtaining your source data and transforming it so that you can use it in your QlikView document. Load script language is SQL-like in its appearance and uses C-style comments (// Comment or /* multi-line comment */), however as far as I can research there has been no official comment on what language it was originally based on.

You can edit this script using the script editor Ctrl+E.

You find documentation on the syntax in the QlikView help installed with the application, or via the Reference manual which you can find here: http://community.qlik.com/docs/DOC-4549

Module Scripts are methods that you can use to interact with the QlikView object model, for example, you can change font of objects (e.g. charts, buttons) or perhaps select values in List Boxes automatically. These are the type of scripts that you linked to in your question.

You may edit these scripts in the module editor Ctrl+M and they may be written in VBScript or JScript. If the script is written in VBScript, then any comments begin with a single quote, e.g. ' this is a comment.

You can find documentation on the QlikView object model at http://community.qlik.com/docs/DOC-2640.

like image 57
i_saw_drones Avatar answered Oct 29 '22 22:10

i_saw_drones


The Load language is pretty similar to VB, however it is based on the Lua Language as you can see in: http://documentation.qlikview.com/expressor/3.8/expressor_datascript_language/datascript_language_reference_guide/The_Datascript_language.htm

like image 44
jclozano Avatar answered Oct 29 '22 21:10

jclozano