topic Re: Need Help... in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/569491#M1119513 <HTML><HEAD></HEAD><BODY><P>[ASN Qty]-ApplyMap('Mapping', Material &amp; Plant,if([Rwip Qty])&lt;0 or ISNULL([Rwip Qty]),0) ) as Final_ASN_Qty</P></BODY></HTML> Sat, 25 Jan 2014 17:12:26 GMT MK_QSL 2014-01-25T17:12:26Z Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569490#M1119512 <HTML><HEAD></HEAD><BODY><P style="font-family: arial, sans-serif; color: #222222;">Hi All,</P><P></P><P style="font-family: arial, sans-serif; color: #222222;">PFA,</P></BODY></HTML> Sat, 25 Jan 2014 17:02:52 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569490#M1119512 2014-01-25T17:02:52Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569491#M1119513 <HTML><HEAD></HEAD><BODY><P>[ASN Qty]-ApplyMap('Mapping', Material &amp; Plant,if([Rwip Qty])&lt;0 or ISNULL([Rwip Qty]),0) ) as Final_ASN_Qty</P></BODY></HTML> Sat, 25 Jan 2014 17:12:26 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569491#M1119513 MK_QSL 2014-01-25T17:12:26Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569492#M1119514 <HTML><HEAD></HEAD><BODY><P>Or change the mapping load table as</P><P></P><P>Mapping:</P><P>Mapping LOAD plant_Key,</P><P>&nbsp; if([Rwip Qty]&lt;0 or IsNull([Rwip Qty]),0,[Rwip Qty]) as [Rwip Qty] Resident RWIP_1;</P></BODY></HTML> Sat, 25 Jan 2014 17:19:47 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569492#M1119514 MK_QSL 2014-01-25T17:19:47Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569493#M1119515 <HTML><HEAD></HEAD><BODY><P>Please check enclosed file...</P></BODY></HTML> Sat, 25 Jan 2014 22:26:07 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569493#M1119515 MK_QSL 2014-01-25T22:26:07Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569494#M1119516 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>In this case Mapping function only it takes 1st value comparing with duplicate values</P><P><STRONG>EX:&nbsp; </STRONG> ASN-RWIP=ASN_QTY_sample</P><P>10-20=-10</P><P>10-30=-20</P><P>10-80=-70</P><P><IMG __jive_id="52097" alt="Sample.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/52097_Sample.png" style="width: 620px; height: 93px;" /></P><P></P><P>But, here consider only with <STRONG>-70</STRONG></P></BODY></HTML> Sun, 26 Jan 2014 06:03:09 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569494#M1119516 2014-01-26T06:03:09Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569495#M1119517 <HTML><HEAD></HEAD><BODY><P>Dear Sunil,</P><P>Mapping Load Table only take two columns/dimensions and also there should be no duplication in this table.</P><P>Otherwise, AppyMap function will take only the First Value.</P><P>Also, due to duplication in Mapping Load Table, ApplyMap will create duplicated rows...</P></BODY></HTML> Sun, 26 Jan 2014 09:14:23 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569495#M1119517 MK_QSL 2014-01-26T09:14:23Z Re: Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569496#M1119518 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P>One more problem..</P><P><IMG alt="Capture.PNG" class="jive-image" height="178" src="https://community.qlik.com/legacyfs/online/52156_Capture.PNG" style="width: 362px; height: 178.0806451612903px;" width="362" /></P><P></P><P>In my <STRONG>Plant_key</STRONG> last value <STRONG>0606ABCA017</STRONG></P><P><STRONG>ASN QTY- Rwip Qty= Final_ASN_Qty</STRONG></P><P>but here ASN_QTY value Null value(Null value should should be Zero her)</P><P>then <STRONG>0-14=-14</STRONG></P><P></P><P><STRONG>NULL() values should be Zero in All columns</STRONG></P></BODY></HTML> Mon, 27 Jan 2014 13:34:54 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569496#M1119518 2014-01-27T13:34:54Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569497#M1119519 <HTML><HEAD></HEAD><BODY><P>Replace with this in your script...</P><P>IF(NOT ISNULL([ASN Qty]),if([ASN Qty]-ApplyMap('Mapping', Material &amp; Plant)&lt;0,0,[ASN Qty]-ApplyMap('Mapping', Material &amp; Plant,0)),0) as Final_ASN_Qty</P></BODY></HTML> Mon, 27 Jan 2014 13:45:50 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569497#M1119519 MK_QSL 2014-01-27T13:45:50Z Re: Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569498#M1119520 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>How to calculate group by Plant_Key wise</P><P>sum(ASN_QTY -Sum(RWip_Qty) = Eff ASN</P><P></P><P>Eff_ASN i want to show group wise based on Plant_Key</P><P></P><P>PFA..</P></BODY></HTML> Tue, 28 Jan 2014 17:05:11 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569498#M1119520 2014-01-28T17:05:11Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569499#M1119521 <HTML><HEAD></HEAD><BODY><P>please anyone can help me...........</P></BODY></HTML> Tue, 28 Jan 2014 17:25:03 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569499#M1119521 2014-01-28T17:25:03Z Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569500#M1119522 <HTML><HEAD></HEAD><BODY><P>Didn't catch you what is your requirement. Can you describe further in details?</P></BODY></HTML> Tue, 28 Jan 2014 17:25:24 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569500#M1119522 MK_QSL 2014-01-28T17:25:24Z Re: Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569501#M1119523 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>Here it shows duplicate records in Sheet1 </P><P></P><P>PFA,,</P></BODY></HTML> Tue, 28 Jan 2014 17:32:28 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569501#M1119523 2014-01-28T17:32:28Z Re: Re: Re: Need Help... https://community.qlik.com/t5/QlikView/Need-Help/m-p/569502#M1119524 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to merge with 2 columns in 1</P><P><STRONG>ATP_Qty and Rwip_Qty</STRONG></P><P></P><P>PFA,</P></BODY></HTML> Wed, 29 Jan 2014 14:35:47 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/569502#M1119524 2014-01-29T14:35:47Z