topic if statement in load script in QlikView https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238226#M89153 <HTML><HEAD></HEAD><BODY><P>else part is optional in If statement</P><P>Rgds,<BR />Artjoms</P></BODY></HTML> Wed, 11 Nov 2009 17:52:01 GMT Anonymous 2009-11-11T17:52:01Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238221#M89148 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>what is not correct ?</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">LOAD<BR />Hierarchy,<BR />NetValue,<BR />if((BP-Account= 'Corporate'), 1), if((BP-Account= 'Key'), 2),<BR />if((BP-Account= 'Standard'), 3), if((BP-Account= 'Private'), 4)<BR />as CorpAccGrID<BR />from data</PRE><BR /><BR /> <P></P><P>Thanks</P><BR /><BR /></BODY></HTML> Wed, 11 Nov 2009 17:36:21 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238221#M89148 2009-11-11T17:36:21Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238222#M89149 <HTML><HEAD></HEAD><BODY><P>Else part missing from your expression</P></BODY></HTML> Wed, 11 Nov 2009 17:39:09 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238222#M89149 2009-11-11T17:39:09Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238223#M89150 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P></P><P></P><P></P><P>if</P><P></P><P></P>((BP-Account= 'Corporate'), 1, if((BP-Account= 'Key'), 2,if((BP-Account= 'Standard'), 3, if((BP-Account= 'Private'), 4 <P>))))</P><P>as</P><P></P><P></P><P>CorpAccGrID</P><BR /><BR /> <BR /><BR /></BODY></HTML> Wed, 11 Nov 2009 17:40:41 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238223#M89150 2009-11-11T17:40:41Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238224#M89151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks</P><P>you mean</P><P style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;"></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">LOAD<BR style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;" />Hierarchy,<BR style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;" />NetValue,<BR />if((BP-Account= 'Corporate'), 1) else if((BP-Account= 'Key'), 2) else<BR style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;" />if((BP-Account= 'Standard'), 3) else if((BP-Account= 'Private'), 4)<BR style="margin:0cm 0cm 0pt;mso-layout-grid-align:none;" />as CorpAccGrID<BR />from data</PRE></BLOCKQUOTE><BR /><BR /> <P></P></BODY></HTML> Wed, 11 Nov 2009 17:42:28 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238224#M89151 2009-11-11T17:42:28Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238225#M89152 <HTML><HEAD></HEAD><BODY><P>Try like this</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />If([BP-Account]='Corporate',1,<BR /> If([BP-Account]='Key',2,<BR /> If([BP-Account]='Standard',3,<BR /> If([BP-Account]='Private',4)))) as CorpAccGrID<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>In all other cases CorpAccGrID will be Null.</P><P>Rgds,<BR />Artjoms</P></BODY></HTML> Wed, 11 Nov 2009 17:49:18 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238225#M89152 Anonymous 2009-11-11T17:49:18Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238226#M89153 <HTML><HEAD></HEAD><BODY><P>else part is optional in If statement</P><P>Rgds,<BR />Artjoms</P></BODY></HTML> Wed, 11 Nov 2009 17:52:01 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238226#M89153 Anonymous 2009-11-11T17:52:01Z if statement in load script https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238227#M89154 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks for all help .</P><P>That works.</P></BODY></HTML> Wed, 11 Nov 2009 17:57:26 GMT https://community.qlik.com/t5/QlikView/if-statement-in-load-script/m-p/238227#M89154 2009-11-11T17:57:26Z