Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

insert value in field via macro

Hi,

I am trying to create a macro to insert the value of a variable declared in QV in the fields of a column.

I tried this way but it is wrong

sub ChangeValue

     if ($ (variable) = "Y")

     ActiveDocument.Fields ("Field1"). SetContent "y"

     if ($ (variable) = "N")

     ActiveDocument.Fields ("Field1"). SetContent "n"

end sub

I am not good in VB script, can anyone help me? thanks

0 Replies