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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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
Partner - Master
Partner - Master

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.