Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Honored Contributor

Loading inline data via automation

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.

Community Browser