Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading inline data via automation

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

1 Reply
pover
Luminary Alumni
Luminary Alumni

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.