topic Get all objects of a specific Sheet in QlikView

Get all objects of a specific Sheet

ThomasGorr — Mon, 26 Jan 2026 16:26:21 GMT

Hi all!

Is it possible to get all objects which are on a specific Sheet?

For example something like this:

var sheet = qv.getSheetByName("DATA");

var obj = sheet.getObject("LB01").Data.Rows[0][0];

Where "DATA" is the name of the Sheet and LB01 is a Listbox within this sheet.

Thanks for the answer,

Thomas.

m_woolf — Tue, 16 Feb 2016 18:21:39 GMT

This is from the API Giuide:

rem ** remove borders from all listboxes on active sheet **

set x = ActiveDocument.ActiveSheet.GetSheetObjects

Objects = x.SheetObjects

For i = lBound(Objects) To uBound(Objects)

set obj = Objects(i)

if obj.GetObjectType = 1 then 'list boxes

set p = obj.GetProperties

p.Layout.Frame.BorderEffect = 0 'no border

obj.SetProperties p

end if

nagireddy_qv — Tue, 16 Feb 2016 18:35:45 GMT

Hi,

Here is the API guide that might help you.