topic How to get a field value into a variable through macro in QlikView https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231304#M83072 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to assign a field value to a variable through macro , on document open.</P><P>Field contain only one value,</P><P>How to assign it to a variable</P></BODY></HTML> Thu, 23 Dec 2010 08:18:04 GMT 2010-12-23T08:18:04Z How to get a field value into a variable through macro https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231304#M83072 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to assign a field value to a variable through macro , on document open.</P><P>Field contain only one value,</P><P>How to assign it to a variable</P></BODY></HTML> Thu, 23 Dec 2010 08:18:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231304#M83072 2010-12-23T08:18:04Z How to get a field value into a variable through macro https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231305#M83073 <HTML><HEAD></HEAD><BODY><P>Try this</P><H4>ActiveDocument.Variables("vVarA").SETCONTENT ActiveDocument.Fields("SomeField").GetSelectedValues.item(0).text,TRUE</H4></BODY></HTML> Thu, 23 Dec 2010 08:33:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231305#M83073 2010-12-23T08:33:08Z How to get a field value into a variable through macro https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231306#M83074 <HTML><HEAD></HEAD><BODY><P>Actually field contain only one value which is not selected</P><P>So we can't use <STRONG>GetSelectedValues</STRONG></P><P><STRONG>pls give alternative ,</STRONG></P><P><STRONG>if we want to get all the values of a field (selected / not selected)</STRONG></P><P><STRONG>and want to assign it to a variable</STRONG></P><P></P><BR /><BR /></BODY></HTML> Thu, 23 Dec 2010 09:53:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231306#M83074 2010-12-23T09:53:59Z How to get a field value into a variable through macro https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231307#M83075 <HTML><HEAD></HEAD><BODY><P>Actually Field that i am using contain only one value</P><P>I don't want to select it ,</P><P>I want values of field(<STRONG>both selected and non selected</STRONG>) by default through macro</P><P>so</P><P></P><BR /><BR /> <P><STRONG>Getselectedvalues can't work</STRONG></P></BODY></HTML> Thu, 23 Dec 2010 09:56:51 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231307#M83075 2010-12-23T09:56:51Z How to get a field value into a variable through macro https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231308#M83076 <HTML><HEAD></HEAD><BODY><P>Try this:</P><H4>IF ActiveDocument.Fields("SOMEFIELD").GetPossibleValues.COUNT=1 THEN</H4><H4>ActiveDocument.Variables("vVarA").SETCONTENT ActiveDocument.Fields("SOMEFIELD").GetPossibleValues.item(0).text,TRUE</H4><H4>end if</H4></BODY></HTML> Thu, 23 Dec 2010 10:05:55 GMT https://community.qlik.com/t5/QlikView/How-to-get-a-field-value-into-a-variable-through-macro/m-p/231308#M83076 2010-12-23T10:05:55Z