topic Re: App development in QlikView https://community.qlik.com/t5/QlikView/App-development/m-p/775944#M275112 <HTML><HEAD></HEAD><BODY><P>Hi Bhagirath,</P><P></P><P>I saw ur attachment but it is complex.After some trials i got the solution.</P><P>By using Exists function we can get the answer what i post in the earlier one.</P><P></P><P>try using Where not exists.</P><P></P><P>Thanks </P><P>Sridhar.</P></BODY></HTML> Tue, 24 Mar 2015 11:45:11 GMT sridhar423 2015-03-24T11:45:11Z App development https://community.qlik.com/t5/QlikView/App-development/m-p/775942#M275110 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have two tables.I loaded the two tables ,after concatenating i have a table that consists of Lotno and Prod.Actually Lotno <STRONG style="color: #ff0000;">1 </STRONG>has two Prod <SPAN style="color: #ff0000;"><STRONG>A</STRONG></SPAN> and <SPAN style="color: #ff0000;"><STRONG>D</STRONG></SPAN>.But when i select&nbsp; "<STRONG style="color: #ff0000;">1"</STRONG>&nbsp; i need to get the Prod <STRONG style="color: #ff0000;">A</STRONG> only.if the two tables contains same Lotno priority should be given to Table1 only.</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>&nbsp; Table1&nbsp; </STRONG></P><P><STRONG> </STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 146pt;" width="195"><TBODY><TR style="height: 15.0pt;"><TD height="20" style="height: 15.0pt; width: 68pt;" width="91">Lotno</TD><TD style="width: 78pt;" width="104">Prod</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">1</TD><TD>A</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">2</TD><TD>B</TD></TR><TR style="height: 15.0pt;"><TD align="right" height="20" style="height: 15.0pt;">3</TD><TD>C</TD></TR></TBODY></TABLE><P></P><P><STRONG>&nbsp;&nbsp;&nbsp; Table2</STRONG></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 96pt;" width="128"><TBODY><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt; width: 48pt;" width="64">Lotno</TD><TD class="xl65" style="border-left: none; width: 48pt;" width="64">Prod</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">1</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">3</TD><TD class="xl65" style="border-top: none; border-left: none;">E</TD></TR><TR style="height: 15.0pt;"><TD align="right" class="xl65" height="20" style="height: 15.0pt; border-top: none;">5</TD><TD class="xl65" style="border-top: none; border-left: none;">F</TD></TR></TBODY></TABLE><P></P><P>Thanks</P><P>Sridhar.</P></BODY></HTML> Tue, 24 Mar 2015 09:23:26 GMT https://community.qlik.com/t5/QlikView/App-development/m-p/775942#M275110 sridhar423 2015-03-24T09:23:26Z Re: App development https://community.qlik.com/t5/QlikView/App-development/m-p/775943#M275111 <HTML><HEAD></HEAD><BODY><P>Hi Shridhar,</P><P></P><P>Attached is a sample app for solution</P></BODY></HTML> Tue, 24 Mar 2015 09:59:53 GMT https://community.qlik.com/t5/QlikView/App-development/m-p/775943#M275111 Anonymous 2015-03-24T09:59:53Z Re: App development https://community.qlik.com/t5/QlikView/App-development/m-p/775944#M275112 <HTML><HEAD></HEAD><BODY><P>Hi Bhagirath,</P><P></P><P>I saw ur attachment but it is complex.After some trials i got the solution.</P><P>By using Exists function we can get the answer what i post in the earlier one.</P><P></P><P>try using Where not exists.</P><P></P><P>Thanks </P><P>Sridhar.</P></BODY></HTML> Tue, 24 Mar 2015 11:45:11 GMT https://community.qlik.com/t5/QlikView/App-development/m-p/775944#M275112 sridhar423 2015-03-24T11:45:11Z Re: App development https://community.qlik.com/t5/QlikView/App-development/m-p/775945#M275113 <HTML><HEAD></HEAD><BODY><P>mine was one of the solutions and not the only solution.</P></BODY></HTML> Wed, 25 Mar 2015 03:49:51 GMT https://community.qlik.com/t5/QlikView/App-development/m-p/775945#M275113 Anonymous 2015-03-25T03:49:51Z