topic Re: Please Urgent Help Required in QlikView https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512154#M191354 <HTML><HEAD></HEAD><BODY><P>Please see if the attached qvw helps.</P></BODY></HTML> Wed, 21 Aug 2013 10:22:21 GMT abeyphilip 2013-08-21T10:22:21Z Please Urgent Help Required https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512152#M191352 <HTML><HEAD></HEAD><BODY><P><STRONG>Hi Community,</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Please Help me Its Very urgent. </STRONG></P><P></P><P><STRONG>I have Data into 2 different sheets Like</STRONG></P><P><STRONG>Sheet 1</STRONG></P><TABLE border="1" class="jiveBorder" height="100" style="border: 1px solid rgb(0, 0, 0); width: 449px; height: 91px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>WebTopNum<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">OpenError</TH></TR><TR><TD style="padding: 2px;">1111</TD><TD style="padding: 2px;">PL</TD><TD style="padding: 2px;">1</TD></TR><TR><TD>2222</TD><TD>BL</TD><TD></TD></TR><TR><TD style="padding: 2px;">3333</TD><TD style="padding: 2px;">BL</TD><TD style="padding: 2px;">2</TD></TR></TBODY></TABLE><P></P><P><STRONG>and Sheet 2</STRONG></P><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 447px; height: 76px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>WebTopNum<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Status</TH></TR><TR><TD style="padding: 2px;">1111</TD><TD style="padding: 2px;">PL</TD><TD style="padding: 2px;">Open</TD></TR><TR><TD>2222</TD><TD>BL</TD><TD>Closed</TD></TR></TBODY></TABLE><P></P><P><STRONG>I want Output Like this</STRONG></P><TABLE border="1" class="jiveBorder" height="75" style="border: 1px solid rgb(0, 0, 0); width: 449px; height: 38px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Type<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Raised<BR /></STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Open<BR /></STRONG></TH></TR><TR><TD style="padding: 2px;">PL</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">BL</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P><STRONG><BR /></STRONG></P><P><STRONG>In Output file Raised means OpenErrors from sheet1 and Open means Status from sheet2.</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Thanks and Regards,</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Vishal Waghole<BR /></STRONG></P></BODY></HTML> Wed, 21 Aug 2013 09:51:37 GMT https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512152#M191352 VishalWaghole 2013-08-21T09:51:37Z Re: Please Urgent Help Required https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512153#M191353 <HTML><HEAD></HEAD><BODY><P>Output:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Type,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Status as Open</P><P>From Sheet1;</P><P></P><P>Left Join</P><P></P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Type,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; OpenError as Raised</P><P>From Sheet2</P><P>Where not IsNull(OpenError);</P></BODY></HTML> Wed, 21 Aug 2013 09:56:38 GMT https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512153#M191353 2013-08-21T09:56:38Z Re: Please Urgent Help Required https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512154#M191354 <HTML><HEAD></HEAD><BODY><P>Please see if the attached qvw helps.</P></BODY></HTML> Wed, 21 Aug 2013 10:22:21 GMT https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512154#M191354 abeyphilip 2013-08-21T10:22:21Z Re: Please Urgent Help Required https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512155#M191355 <HTML><HEAD></HEAD><BODY><P>see attached file</P><P>output like this</P><P>.</P><TABLE border="0" cellpadding="0" cellspacing="0" width="294"><TBODY><TR><TD class="xl63" height="17" width="98">Type</TD><TD class="xl64" width="98">Raised</TD><TD class="xl64" style="border-left: none;" width="98">Open</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">PL</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">1</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">BL</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 21 Aug 2013 10:33:35 GMT https://community.qlik.com/t5/QlikView/Please-Urgent-Help-Required/m-p/512155#M191355 2013-08-21T10:33:35Z