topic Re: If right function in QlikView https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029973#M347831 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>LOAD Codes,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dates,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Codes = 'A3', dates) as New_Dates,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Codes = 'A3', 'Y', 'N') as Flag</STRONG></P><P><STRONG>FROM Source;</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 16:11:59 GMT sunny_talwar 2016-03-08T16:11:59Z If right function https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029972#M347830 <HTML><HEAD></HEAD><BODY><P>Hi guys </P><P></P><P>Abit stuck on this</P><P></P><P>I wanted something like</P><P></P><P>My data shows dates and codes </P><P>Codes are A1, A2, A3 etc</P><P></P><P>I want A3 to say Y and others to say N</P><P></P><P>If (right = 3, then show date)</P><P></P><P>Thanks</P><P></P><P></P><P>Adil</P></BODY></HTML> Tue, 08 Mar 2016 16:09:36 GMT https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029972#M347830 Anonymous 2016-03-08T16:09:36Z Re: If right function https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029973#M347831 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>LOAD Codes,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dates,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Codes = 'A3', dates) as New_Dates,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If(Codes = 'A3', 'Y', 'N') as Flag</STRONG></P><P><STRONG>FROM Source;</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 16:11:59 GMT https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029973#M347831 sunny_talwar 2016-03-08T16:11:59Z Re: If right function https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029974#M347832 <HTML><HEAD></HEAD><BODY><P>If(right(Codes,1)=3,'Y','N') as Flag</P></BODY></HTML> Tue, 08 Mar 2016 16:12:17 GMT https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029974#M347832 Digvijay_Singh 2016-03-08T16:12:17Z Re: If right function https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029975#M347833 <HTML><HEAD></HEAD><BODY><P>Thanks Digvijay</P></BODY></HTML> Tue, 08 Mar 2016 17:05:51 GMT https://community.qlik.com/t5/QlikView/If-right-function/m-p/1029975#M347833 Anonymous 2016-03-08T17:05:51Z