Access data in your Qlikview via API

[pauljohansson]

Hi,

If I have published a Qlikview on the Accesspoint. Would it then be possible to access its data based on bookmarks via a API?

Thanks in advance,

Paul

[petter]

Yes it is. The API that you can use is COM. So you can reference the type library called QlikTech.QlikView. A prerequisite for this is that you install QlikView Desktop. The type library and COM object will then be installed when the QlikView Desktop is installed.

You can through COM access both local QVW-files and files located on a QlikView Server.  Through the object model exposed through COM you can select bookmarks and then access the subset of data. Mind you this is not a high performance massive data manipulation API.

[pauljohansson]

Hi Petter,

Thanks for your reply!

I have trouble finding a simple example on this. Perhaps you have a basic code example on this, or maybe you can point in any direction on how to access a qvw using COM and perform a simple(any) operation.

thanks in advance,

br

Paul

[petter]

Which language would you like to use to access the COM-API from? VBscript, JScript, VBA, C#, VB.NET ?

Any of them could be used - but giving you an example that is relevant is better right?

[petter]

Here is an example in C# with Visual Studio Community 2013.

- To add a reference to QlikView type library and get access to the COM Object Model you need to go to

     PROJECT / Add Reference / Type Library    (see the dialog box underneath) :

The nice thing here is that you get full IntelliSense into the object model of QlikView and it is so much nicer than having to lookup the API-documentation manually.