topic AW:Quick help in if formula in QlikView https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215850#M69255 <HTML><HEAD></HEAD><BODY><P>Syntax seems to be correct</P></BODY></HTML> Wed, 14 Oct 2009 18:35:26 GMT 2009-10-14T18:35:26Z Quick help in if formula https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215849#M69254 <HTML><HEAD></HEAD><BODY><P>Unfortunately today I've got problem with connection to my databases. I'm trying from few days build customer segmentaion. Probably "I'm in home" but I need to know if below code is correct. I can't check this with QV file. I'm interesting of cheking <STRONG>if formula</STRONG> with <STRONG>and</STRONG></P><P></P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />Segment:<BR />load<BR />[Client number],<BR />[BU],<BR />[Factory],<BR />[Sales person (Client)],<BR />if([Factory]='NAM', 'FIRE',if(([Sales person (Client)]='170013' and<BR /> [Factory]='PRU'), 'PROJEKTY',[BU])) as [Business Unit]<BR />resident Sales;<BR /><BR /><BR /></PRE><BR /><BR /></BODY></HTML> Wed, 14 Oct 2009 18:27:57 GMT https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215849#M69254 2009-10-14T18:27:57Z AW:Quick help in if formula https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215850#M69255 <HTML><HEAD></HEAD><BODY><P>Syntax seems to be correct</P></BODY></HTML> Wed, 14 Oct 2009 18:35:26 GMT https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215850#M69255 2009-10-14T18:35:26Z AW:Quick help in if formula https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215851#M69256 <HTML><HEAD></HEAD><BODY><P>Thanks a lot:) This really simplify my work:):)</P></BODY></HTML> Wed, 14 Oct 2009 18:44:27 GMT https://community.qlik.com/t5/QlikView/Quick-help-in-if-formula/m-p/215851#M69256 2009-10-14T18:44:27Z