topic Re: API in VB in QlikView

API in VB

Tue, 19 Jun 2012 15:47:05 GMT

Can anyone advise how to make selections using API via VB?

To date I have the below to open a file, refresh it, select the LIstbox i want to make the selection in but i cant get the IArrayOfRect Add methdo to work?? I can get it to Select all but i would like to eb able to specify a single select.

Dim QvApp As New QlikView.Application

Dim QVDoc As New QlikView.Document

QVDoc = QvApp.OpenDoc("C:\pgrp.qvw")

QVDoc.ReloadEx()

Dim sel As QlikView.ListBox

sel = QVDoc.GetSheetObject("LB02")

Dim pband As QlikView.IArrayOfRect

pband.Add("M")

sel.GeneralSelect(pband)

sel.SendToExcel()

QVDoc.CloseDoc()

QvApp.Quit()

Cheers

Mark

Re: API in VB

m_woolf — Tue, 19 Jun 2012 16:06:30 GMT

What field is displayed in the listbox?

To select in a field:

Activedocument.fields("Fieldname").Select "M*"

In the API Guide you might also lookup ToggleSelect and SelectExcluded

Re: API in VB

Tue, 19 Jun 2012 16:12:43 GMT

Thanks for reply

I tried ...

QVDoc.Fields("LB02").Select("M*")

but i get an error stating that the object referenece is not set to an instance of an object

Re: API in VB

m_woolf — Tue, 19 Jun 2012 16:14:56 GMT

LB02 is not a field. Replace the LB02 with the fieldname that is displayed in the listbox

Re: API in VB

Tue, 19 Jun 2012 16:18:13 GMT

thats it, so simple

I assumed it would use the ID, guess it is one of the read the def 'fieldname' !!

cheers