Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mightyqlikers
Creator III
Creator III

vb scrip to display name

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

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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)

    next

next

- Marcus

mightyqlikers
Creator III
Creator III
Author

hi marcus,

thanks for u r reply ,

but i have got in different way.

like

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