topic If ....WHERE in QlikView

topic If ....WHERE in QlikView https://community.qlik.com/t5/QlikView/If-WHERE/m-p/721161#M258997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table bellow, the code for CCC is empty, my need is : if type is '3', then show code of AAA as code of CCC.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 270px;"><TBODY><TR><TD height="20" width="78">CUSTOMER </TD><TD width="64">NAME </TD><TD width="64">TYPE</TD><TD width="64">CODE</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>BBB</TD><TD align="right">2</TD><TD align="right">202</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">103</TD></TR></TBODY></TABLE><P></P><P>The final table will be like bellow</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 270px;"><TBODY><TR><TD height="20" width="78">CUSTOMER </TD><TD width="64">NAME </TD><TD width="64">TYPE</TD><TD width="64">CODE</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>BBB</TD><TD align="right">2</TD><TD align="right">202</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">103</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">103</TD></TR></TBODY></TABLE><P></P><P></P><P>how to proceed?</P></BODY></HTML> Sun, 06 Jul 2014 21:42:46 GMT 2014-07-06T21:42:46Z If ....WHERE https://community.qlik.com/t5/QlikView/If-WHERE/m-p/721161#M258997 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table bellow, the code for CCC is empty, my need is : if type is '3', then show code of AAA as code of CCC.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 270px;"><TBODY><TR><TD height="20" width="78">CUSTOMER </TD><TD width="64">NAME </TD><TD width="64">TYPE</TD><TD width="64">CODE</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>BBB</TD><TD align="right">2</TD><TD align="right">202</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">103</TD></TR></TBODY></TABLE><P></P><P>The final table will be like bellow</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 270px;"><TBODY><TR><TD height="20" width="78">CUSTOMER </TD><TD width="64">NAME </TD><TD width="64">TYPE</TD><TD width="64">CODE</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>BBB</TD><TD align="right">2</TD><TD align="right">202</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">101</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">102</TD></TR><TR><TD height="20">FFF</TD><TD>CCC</TD><TD align="right">3</TD><TD align="right">103</TD></TR><TR><TD height="20">FFF</TD><TD>AAA</TD><TD align="right">1</TD><TD align="right">103</TD></TR></TBODY></TABLE><P></P><P></P><P>how to proceed?</P></BODY></HTML> Sun, 06 Jul 2014 21:42:46 GMT https://community.qlik.com/t5/QlikView/If-WHERE/m-p/721161#M258997 2014-07-06T21:42:46Z Re: If ....WHERE https://community.qlik.com/t5/QlikView/If-WHERE/m-p/721162#M258998 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Hi,</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Try like this</P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Data:</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">LOAD</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">     CUSTOMER,</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">     NAME,</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">     TYPE</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">     IF(TYPE= 3, '103', <SPAN style="font-weight: inherit; font-style: inherit;">CODE</SPAN>) AS <SPAN style="font-weight: inherit; font-style: inherit;">CODE</SPAN></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit;">FROM DataSource;</SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Regards,</P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Jagan.</P><UL><LI><A _jive_internal="true" href="https://community.qlik.com/update-advanced-comment.jspa?id=562637" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"></A></LI></UL></BODY></HTML> Mon, 07 Jul 2014 02:30:41 GMT https://community.qlik.com/t5/QlikView/If-WHERE/m-p/721162#M258998 jagan 2014-07-07T02:30:41Z