topic Modify field value in QlikView https://community.qlik.com/t5/QlikView/Modify-field-value/m-p/153149#M30302 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I would like to change the value of a field.</P><P>Example<BR />I have a table with tree filds Cod_customer f, Type, Name<BR /> 10, AA, Bart<BR /> 20, BB, Tony<BR /> 30, CC, Alain<BR /><BR /> If cod_cutomer = 30 Then<BR /> Type = 'AA'<BR />end if</P><P>The new value ist available at all my document.</P></BODY></HTML> Mon, 09 Aug 2010 13:08:14 GMT shamad 2010-08-09T13:08:14Z Modify field value https://community.qlik.com/t5/QlikView/Modify-field-value/m-p/153149#M30302 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I would like to change the value of a field.</P><P>Example<BR />I have a table with tree filds Cod_customer f, Type, Name<BR /> 10, AA, Bart<BR /> 20, BB, Tony<BR /> 30, CC, Alain<BR /><BR /> If cod_cutomer = 30 Then<BR /> Type = 'AA'<BR />end if</P><P>The new value ist available at all my document.</P></BODY></HTML> Mon, 09 Aug 2010 13:08:14 GMT https://community.qlik.com/t5/QlikView/Modify-field-value/m-p/153149#M30302 shamad 2010-08-09T13:08:14Z Re. :Modify field value https://community.qlik.com/t5/QlikView/Modify-field-value/m-p/153150#M30303 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>In your QV load script, you have to do this :</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">MyTable:<BR />LOAD Cod_customer,<BR />if(Cod_customer=30,'AA',Type) as Type,<BR />Name<BR />FROM MyFic;</PRE></BLOCKQUOTE><BR /><BR /> <P></P></BODY></HTML> Mon, 09 Aug 2010 14:25:17 GMT https://community.qlik.com/t5/QlikView/Modify-field-value/m-p/153150#M30303 martin59 2010-08-09T14:25:17Z