topic Re: vb scrip to display name in QlikView

vb scrip to display name

mightyqlikers — Fri, 11 Dec 2015 08:58:39 GMT

Dear Qlikers,

i have two fields namely empcode and empname in app

i am looping through empcodes to send mail.

in mail body i want to display empname with repspect to empcode in mail.

kindly suggets.

Regards

$@M

Re: vb scrip to display name

marcus_sommer — Fri, 11 Dec 2015 15:21:53 GMT

If you have dependencies between different fields-values it's often easier to loop through a tablebox instead of reading and synchronizing values from several fields. See here a simple example and more could you find within the APIGuide.qvw in your install-folder:

set table = ActiveDocument.GetSheetObject( "TB01" )

w = table.GetColumnCount

h = table.GetRowCount

set CellMatrix = table.GetCells2(0,0,w,h)

for RowIter=0 to h-1

for ColIter=0 to w-1

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

- Marcus

Re: vb scrip to display name

mightyqlikers — Mon, 14 Dec 2015 04:25:08 GMT

hi marcus,

thanks for u r reply ,

but i have got in different way.

currently i am looping through empcode right

for single empcode there will be only one empname

so i have created one variable to find empname and used that in vbscript.

Regards

$@M