Loading inline data via automation

Fri, 22 Oct 2010 16:32:49 GMT

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?

Thanks

Loading inline data via automation

pover — Fri, 22 Oct 2010 17:24:57 GMT

Are you looking for something l that I found in the API Guide:

rem ** add new line to script **
set docprop = ActiveDocument.GetProperties
docprop.Script = docprop.Script & "Load * from abc.csv;"
ActiveDocument.SetProperties docprop

And then you can reload the document with:

ActiveDocument.Reload

Regards.

topic Loading inline data via automation in QlikView

Loading inline data via automation

Loading inline data via automation