Discussion Board for collaboration on QlikView Scripting.
I'm trying to figure out whether the above is possible without even having access to the OCX (pending a license). So I've been perusing the documentation and API guide.
All I want to do is create a QlikView document and load it with some data, all in memory and independent of a server. Something like this would be ideal:
var document = ocxControl.CreateDocument();// this doesn't exist - is there an equivalent?document.LoadInline(...);
But I see no LoadInline API. I see a way to do it with the internal scripting engine:
LOAD * INLINE [ ...];
So maybe there's a way for me to pass an arbitrary script to the document for execution?
var document = ocxControl.CreateDocument();// this doesn't exist - or does it?document.Execute("LOAD * INLINE [ ... ];");
Can anyone tell me whether what I'm trying to achieve is even possible?
Are you looking for something l that I found in the API Guide:
rem ** add new line to script **set docprop = ActiveDocument.GetPropertiesdocprop.Script = docprop.Script & "Load * from abc.csv;"ActiveDocument.SetProperties docprop
And then you can reload the document with: