https://community.qlik.com/t5/App-Development/Adding-a-new-Column-with-Logic/m-p/1513219#M36792 <P>Are you saying that if&nbsp;<SPAN>VLD_STAR_INCIDENT_ID = 10000 then show "Open" or if&nbsp;VLD_STAR_INCIDENT_ID = 10001 then show "Closed"?<BR /><BR />If so then<BR /><BR />=If(VLD_STAR_INCIDENT_ID = 10000, 'Open', If(VLD_STAR_INCIDENT_ID = 10001, 'Closed'))<BR /><BR />Should work.</SPAN></P> Wed, 28 Nov 2018 01:02:44 GMT lblumenfeld 2018-11-28T01:02:44Z https://community.qlik.com/t5/App-Development/Adding-a-new-Column-with-Logic/m-p/1513165#M36791 <P>Hello,</P><P>I have a Column name&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/1120i2FD7BB4A16BECFA7/image-size/large?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>The Column is VLD_STAR_INCIDENT_ID. I want to see the column like below. When&nbsp;<SPAN>VLD_STAR_INCIDENT_ID = 10000, it is Open&nbsp; and if&nbsp;&nbsp;&nbsp;VLD_STAR_INCIDENT_ID = 10001 , it is Closed. So the Final column should come like : </SPAN></P><P><U><STRONG>Stat_Incident:</STRONG></U></P><P><SPAN>closed</SPAN></P><P><SPAN>Open</SPAN></P><P><SPAN>closed</SPAN></P><P><SPAN>open&nbsp;</SPAN></P><P><SPAN>closed&nbsp;</SPAN></P><P><SPAN>....</SPAN></P><P><SPAN>Please suggest</SPAN></P> Tue, 27 Nov 2018 21:04:29 GMT https://community.qlik.com/t5/App-Development/Adding-a-new-Column-with-Logic/m-p/1513165#M36791 niharika1234 2018-11-27T21:04:29Z https://community.qlik.com/t5/App-Development/Adding-a-new-Column-with-Logic/m-p/1513219#M36792 <P>Are you saying that if&nbsp;<SPAN>VLD_STAR_INCIDENT_ID = 10000 then show "Open" or if&nbsp;VLD_STAR_INCIDENT_ID = 10001 then show "Closed"?<BR /><BR />If so then<BR /><BR />=If(VLD_STAR_INCIDENT_ID = 10000, 'Open', If(VLD_STAR_INCIDENT_ID = 10001, 'Closed'))<BR /><BR />Should work.</SPAN></P> Wed, 28 Nov 2018 01:02:44 GMT https://community.qlik.com/t5/App-Development/Adding-a-new-Column-with-Logic/m-p/1513219#M36792 lblumenfeld 2018-11-28T01:02:44Z