topic Re: value in macro in QlikView

value in macro

manoranjan_d — Mon, 09 Mar 2015 13:01:05 GMT

Hi,

How to get the "value of the field from table box" in the macro coding.

Re: value in macro

marcus_sommer — Mon, 09 Mar 2015 13:08:34 GMT

Have a look on this example from APIGuide.qvw:

set TableBox = ActiveDocument.GetSheetObject( "TB01" )

CellRect = ActiveDocument.GetApplication().GetEmptyRect()

CellRect.Top = 0

CellRect.Left = 0

CellRect.Width = TableBox.GetColumnCount

CellRect.Height = TableBox.GetRowCount

set CellMatrix = TableBox.GetCells( CellRect )

for RowIter=CellRect.Top to CellRect.Height-1

for ColIter=CellRect.Left to CellRect.Width-1

msgbox(CellMatrix(RowIter)(ColIter).Text)

- Marcus

Re: value in macro

manoranjan_d — Mon, 09 Mar 2015 13:14:24 GMT

MARCUS

example if we have client as field in the table box and and it contains 10 different values of different clientname. then how you get the selected client in the macro.

client

xxx1

xxx2

xxx3

xxxx4

xxx10

suppose if i click the xxx10 and the same value has to be passed in the macro what is the coding?

Re: value in macro

Anonymous — Mon, 09 Mar 2015 13:19:06 GMT

//create a variable in UI like :

vClient=GetFieldSelections(Client)

//in macro

DIM vClient1

vClient1=ActiveDocument.GetVariable("vClient").GetContent.String

now your vClient1 is having selected client name (xxx10 )

Re: value in macro

marcus_sommer — Mon, 09 Mar 2015 13:30:16 GMT

Maybe it's easier to run directly through a field instead of using a tablebox:

set val=ActiveDocument.Fields("clientname").GetPossibleValues

for i=0 to val.Count-1

msgbox(val.Item(i).Text)

- Marcus