topic Adding field value in QlikView https://community.qlik.com/t5/QlikView/Adding-field-value/m-p/407443#M151579 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I think this should be relatively easy. I have and [Order Index] field with codes 1-40 for [Sec Diag]. I would like the [Order Index] to display "P" value when there is a populated value in [Prim Diag]. How do add that in the load script?</P></BODY></HTML> Tue, 05 Feb 2013 21:58:48 GMT 2013-02-05T21:58:48Z Adding field value https://community.qlik.com/t5/QlikView/Adding-field-value/m-p/407443#M151579 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I think this should be relatively easy. I have and [Order Index] field with codes 1-40 for [Sec Diag]. I would like the [Order Index] to display "P" value when there is a populated value in [Prim Diag]. How do add that in the load script?</P></BODY></HTML> Tue, 05 Feb 2013 21:58:48 GMT https://community.qlik.com/t5/QlikView/Adding-field-value/m-p/407443#M151579 2013-02-05T21:58:48Z Re: Adding field value https://community.qlik.com/t5/QlikView/Adding-field-value/m-p/407444#M151580 <HTML><HEAD></HEAD><BODY><P>If(not isnull([Prim Diag]), 'P', [Sec Diag]) AS [Order Index]</P></BODY></HTML> Tue, 05 Feb 2013 22:28:29 GMT https://community.qlik.com/t5/QlikView/Adding-field-value/m-p/407444#M151580 2013-02-05T22:28:29Z