Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

New Contributor III

insert value in field via macro


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

Community Browser