topic Re: Create A Field with 3 values depends on condition in QlikView https://community.qlik.com/t5/QlikView/Create-A-Field-with-3-values-depends-on-condition/m-p/1734133#M722658 <P>Hi, im from Brazil.</P><P>Sorry for my english.</P><P>Try this:</P><P>&nbsp;</P><P>LOAD</P><P>IF(Field1 = 1, 'Yes',</P><P>&nbsp; &nbsp; &nbsp;IF(Field = 0, 'No', NULL())) AS Field1</P> Fri, 07 Aug 2020 14:16:48 GMT TiagoCardoso 2020-08-07T14:16:48Z Create A Field with 3 values depends on condition https://community.qlik.com/t5/QlikView/Create-A-Field-with-3-values-depends-on-condition/m-p/1734126#M722656 <P>Hi All,</P><P>Need help in creating a field which contains below value</P><P>IF (Field1 = 1) then Yes OR (field1=0) then No else Null End as Field1.</P><P>Regards.</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Create-A-Field-with-3-values-depends-on-condition/m-p/1734126#M722656 Shinooj_M 2020-11-25T16:16:04Z Re: Create A Field with 3 values depends on condition https://community.qlik.com/t5/QlikView/Create-A-Field-with-3-values-depends-on-condition/m-p/1734133#M722658 <P>Hi, im from Brazil.</P><P>Sorry for my english.</P><P>Try this:</P><P>&nbsp;</P><P>LOAD</P><P>IF(Field1 = 1, 'Yes',</P><P>&nbsp; &nbsp; &nbsp;IF(Field = 0, 'No', NULL())) AS Field1</P> Fri, 07 Aug 2020 14:16:48 GMT https://community.qlik.com/t5/QlikView/Create-A-Field-with-3-values-depends-on-condition/m-p/1734133#M722658 TiagoCardoso 2020-08-07T14:16:48Z