topic Re: check availability in QlikView https://community.qlik.com/t5/QlikView/check-availability/m-p/547895#M1127826 <HTML><HEAD></HEAD><BODY><P>hi, sorry guys. found the solution. thanks</P></BODY></HTML> Fri, 03 Jan 2014 06:33:03 GMT 2014-01-03T06:33:03Z check availability https://community.qlik.com/t5/QlikView/check-availability/m-p/547891#M1127822 <HTML><HEAD></HEAD><BODY><P>hi, i want to check 3 excel sheets to if they are having my items. if they have i want to create a column with 'yes'. how can i do that?</P></BODY></HTML> Fri, 03 Jan 2014 05:24:12 GMT https://community.qlik.com/t5/QlikView/check-availability/m-p/547891#M1127822 2014-01-03T05:24:12Z Re: check availability https://community.qlik.com/t5/QlikView/check-availability/m-p/547892#M1127823 <HTML><HEAD></HEAD><BODY><P>Post some sample to better understand your requirement,</P><P></P><P>Regards</P><P>Nitin</P></BODY></HTML> Fri, 03 Jan 2014 05:31:02 GMT https://community.qlik.com/t5/QlikView/check-availability/m-p/547892#M1127823 Anonymous 2014-01-03T05:31:02Z Re: check availability https://community.qlik.com/t5/QlikView/check-availability/m-p/547893#M1127824 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9pt; font-family: Arial, sans-serif;">Hi Chathurnaga,</SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif;">I am not realize clearly, please post sample excel or script,</SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif;"> </SPAN></P><P><SPAN style="font-size: 9pt; font-family: Arial, sans-serif;">Try to add, when you are load data from excel file ADD <STRONG>where</STRONG> clause, then add concat or “&amp;’ with column name in resident table.</SPAN></P></BODY></HTML> Fri, 03 Jan 2014 05:42:40 GMT https://community.qlik.com/t5/QlikView/check-availability/m-p/547893#M1127824 2014-01-03T05:42:40Z Re: check availability https://community.qlik.com/t5/QlikView/check-availability/m-p/547894#M1127825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you come up with some sample data and explain.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 03 Jan 2014 05:48:25 GMT https://community.qlik.com/t5/QlikView/check-availability/m-p/547894#M1127825 jagan 2014-01-03T05:48:25Z Re: check availability https://community.qlik.com/t5/QlikView/check-availability/m-p/547895#M1127826 <HTML><HEAD></HEAD><BODY><P>hi, sorry guys. found the solution. thanks</P></BODY></HTML> Fri, 03 Jan 2014 06:33:03 GMT https://community.qlik.com/t5/QlikView/check-availability/m-p/547895#M1127826 2014-01-03T06:33:03Z