topic Get Field row in QlikView

Get Field row

Fri, 26 Jun 2009 23:29:32 GMT

Hi, I have troubles with a VBscript function.

The function would have to print all the elements of a field, but I cannot find the right function.

sub print

set fld = ActiveDocument.GetField("Name")

msgBox("The field has" &fld.GetCardinal& "elements") 'with this, I know the number of the elements

(loop)

...

set i=0

msgBox("The" & i & "elements is: ", ?????.text) ' What's the function? <<======

set i=i+1

...

(end loop)

end sub

Thanks

Get Field row

Fri, 26 Jun 2009 23:39:31 GMT

From the APIGuide:

set val = ActiveDocument.Fields("Name").GetSelectedValues
for 1 = 0 to val.Count - 1
 MsgBox(val.Item(i).Text)
next

The Class is IArrayOfFieldValue.

Get Field row

Fri, 26 Jun 2009 23:39:56 GMT

Try fld.Item(i).Text

Talha

Get Field row

Fri, 26 Jun 2009 23:44:38 GMT

That won't work, because fld is pointed to a Field class and that class does not have an Item member.

fld.GetSelectedValues.Item(i).Text may work directly in your message box.

Get Field row

rwunderlich — Sat, 27 Jun 2009 01:03:33 GMT

I don't see a member of Field that returns ALL the values if that's what you are after. However, you can use Evaluate to call the Qlikview FieldValue function.

msgbox ActiveDocument.Evaluate("FieldValue('Name'," &i &")")

-Rob

Get Field row

Sat, 27 Jun 2009 01:29:28 GMT

Rob, you are right, I don't want to use the "getselectedvalues" function, because I want to make a function indipendent from the user selection; besides, the "Item" function doesn't work.

Thank you, I'll try soon the Evaluate method.

Get Field row

Oleg_Troyansky — Sat, 27 Jun 2009 01:47:37 GMT

GetPossibleValues() is another alternative