topic Re: script in QlikView

topic Re: script in QlikView https://community.qlik.com/t5/QlikView/script/m-p/807093#M473066 <HTML><HEAD></HEAD><BODY><P>Maybe...</P><P>LEFT JOIN(OriginalTable)</P><P>LOAD</P><P>Type,</P><P>LEAamt/sum(TOTAL LEAamt) as Calc</P><P>RESIDENT OriginalTable;</P></BODY></HTML> Mon, 24 Nov 2014 16:04:35 GMT 2014-11-24T16:04:35Z script https://community.qlik.com/t5/QlikView/script/m-p/807092#M473065 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have table like this in my datamodel</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 324px;"><TBODY><TR><TD class="xl64" height="18" width="64">Month</TD><TD class="xl65" style="border-left: none;" width="163">Type</TD><TD class="xl66" style="border-left: none;" width="97">LEAmt</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">CUSTOM BROKERS</TD><TD class="xl67" style="border-top: none; border-left: none;">    (1,670,858.99)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">DUTY</TD><TD class="xl67" style="border-top: none; border-left: none;"> (20,790,770.96)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">FREIGHT INBOUND</TD><TD class="xl67" style="border-top: none; border-left: none;">    (2,243,902.26)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">FREIGHT OUTBOUND</TD><TD class="xl67" style="border-top: none; border-left: none;"> (23,816,177.97)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">LOGISTICS OVERHEAD</TD><TD class="xl67" style="border-top: none; border-left: none;">            (1,048.35)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">WAREHOUSING</TD><TD class="xl67" style="border-top: none; border-left: none;">    (5,730,697.68)</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">April</TD><TD class="xl66" style="border-top: none; border-left: none;">TradeUnits</TD><TD class="xl68" style="border-top: none; border-left: none;">     4,051,269.00 </TD></TR></TBODY></TABLE><P></P><P>i have to create another column in my datamodel it should be like this. please help us in scripting</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 542px;"><TBODY><TR><TD class="xl66" height="18" width="64">Month</TD><TD class="xl67" style="border-left: none;" width="163">Type</TD><TD class="xl68" style="border-left: none;" width="97">LEAmt</TD><TD class="xl66" style="border-left: none;" width="77">LEUnitsAmt</TD><TD class="xl73" style="border-left: none;" width="141"> calculation example</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">CUSTOM BROKERS</TD><TD class="xl69" style="border-top: none; border-left: none;">    (1,670,858.99)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">DUTY</TD><TD class="xl69" style="border-top: none; border-left: none;"> (20,790,770.96)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">FREIGHT INBOUND</TD><TD class="xl69" style="border-top: none; border-left: none;">    (2,243,902.26)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">FREIGHT OUTBOUND</TD><TD class="xl69" style="border-top: none; border-left: none;"> (23,816,177.97)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">LOGISTICS OVERHEAD</TD><TD class="xl69" style="border-top: none; border-left: none;">            (1,048.35)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">WAREHOUSING</TD><TD class="xl69" style="border-top: none; border-left: none;">    (5,730,697.68)</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">April</TD><TD class="xl68" style="border-top: none; border-left: none;">TradeUnits</TD><TD class="xl70" style="border-top: none; border-left: none;">     4,051,269.00 </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">CUSTOM BROKERS/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-0.41</TD><TD class="xl71" style="border-top: none; border-left: none;">=-1670858.99/4051269</TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">DUTY/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-5.13</TD><TD class="xl73" style="border-top: none; border-left: none;"> <SPAN style="font-size: 13.63636302948px;">(20,790,770.96)/<SPAN style="font-size: 13.63636302948px;">4051269</SPAN></SPAN></TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">FREIGHT INBOUND/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-0.55</TD><TD class="xl73" style="border-top: none; border-left: none;"> <SPAN style="font-size: 13.63636302948px;">(2,243,902.26)/<SPAN style="font-size: 13.63636302948px;">4,051,269.00</SPAN></SPAN></TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">FREIGHT OUTBOUND/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-5.88</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">LOGISTICS OVERHEAD/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">0.00</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl71" height="17" style="border-top: none;">April</TD><TD class="xl72" style="border-top: none; border-left: none;">WAREHOUSING/Units</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl74" style="border-top: none; border-left: none;">-1.41</TD><TD class="xl73" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>Please help us in scripting</P><P>regards</P><P>ramu</P></BODY></HTML> Mon, 24 Nov 2014 14:54:01 GMT https://community.qlik.com/t5/QlikView/script/m-p/807092#M473065 Anonymous 2014-11-24T14:54:01Z Re: script https://community.qlik.com/t5/QlikView/script/m-p/807093#M473066 <HTML><HEAD></HEAD><BODY><P>Maybe...</P><P>LEFT JOIN(OriginalTable)</P><P>LOAD</P><P>Type,</P><P>LEAamt/sum(TOTAL LEAamt) as Calc</P><P>RESIDENT OriginalTable;</P></BODY></HTML> Mon, 24 Nov 2014 16:04:35 GMT https://community.qlik.com/t5/QlikView/script/m-p/807093#M473066 2014-11-24T16:04:35Z