topic If- then formule in QlikView https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231638#M83345 <HTML><HEAD></HEAD><BODY><P>thank you. I have made a mapping table. I can use this often in future!</P></BODY></HTML> Thu, 07 Oct 2010 20:56:56 GMT francisvandergr 2010-10-07T20:56:56Z If- then formule https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231635#M83342 <HTML><HEAD></HEAD><BODY><P></P><H3>Hello</H3><H3>Often i use this kind of formula: if (CategoryID= 5 or CategoryID=6,'Footwear','Clothing') as CategoryType</H3><P>Now i have a problem with a field: status In this field i can have 3 values</P><P>O , M or F ; this values i wanna translate to</P><P>O=Off M=Mag and F=Fac and the field must have the name Status</P><P>if (Status=O, .................................. ?</P><P>Who can help</P><P></P><P></P><BR /><BR /></BODY></HTML> Thu, 07 Oct 2010 20:23:25 GMT https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231635#M83342 francisvandergr 2010-10-07T20:23:25Z If- then formule https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231636#M83343 <HTML><HEAD></HEAD><BODY><P>Hello Francis,</P><P>You may use something like (untested)</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">If(Pick(Match(Status, 'O', 'M', 'F'), 'Off', 'Mag', 'Fac'))</PRE></BLOCKQUOTE><BR /><BR /> <P>But I'd strongly recommend you to use a mapping table:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">StatusMap:MAPPING LOAD * INLINE [Input, OutputO, OffM, MagF, Fac]; LOAD *, ApplyMap('StatusMap', Status) AS StatusFROM file.qvd (qvd);</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps</P></BODY></HTML> Thu, 07 Oct 2010 20:42:31 GMT https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231636#M83343 Miguel_Angel_Baeyens 2010-10-07T20:42:31Z If- then formule https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231637#M83344 <HTML><HEAD></HEAD><BODY><P>You can use something more simple.....</P><P>IF(Status='0','Off',IF(Status='M','Mag','FAC'))</P><P></P><P></P></BODY></HTML> Thu, 07 Oct 2010 20:56:53 GMT https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231637#M83344 2010-10-07T20:56:53Z If- then formule https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231638#M83345 <HTML><HEAD></HEAD><BODY><P>thank you. I have made a mapping table. I can use this often in future!</P></BODY></HTML> Thu, 07 Oct 2010 20:56:56 GMT https://community.qlik.com/t5/QlikView/If-then-formule/m-p/231638#M83345 francisvandergr 2010-10-07T20:56:56Z