topic Re: Mapping and sum() in App Development

topic Re: Mapping and sum() in App Development https://community.qlik.com/t5/App-Development/Mapping-and-sum/m-p/1087389#M18136 <HTML><HEAD></HEAD><BODY><P>Answered it here -> <A href="https://community.qlik.com/thread/209729">Mapping load and sum()</A></P></BODY></HTML> Wed, 16 Mar 2016 20:36:37 GMT sunny_talwar 2016-03-16T20:36:37Z Mapping and sum() https://community.qlik.com/t5/App-Development/Mapping-and-sum/m-p/1087388#M18135 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i need a solution to map a distinct datafiled to another table.</P><P></P><P>Table1:</P><TABLE><TBODY><TR><TD><STRONG>Gewerk</STRONG> </TD><TD><STRONG>Price</STRONG> </TD><TD><STRONG>Work</STRONG>    </TD></TR><TR><TD>Building   </TD><TD>150</TD><TD>Roof</TD></TR><TR><TD>Planning   </TD><TD>100</TD><TD>Kitchen</TD></TR><TR><TD>Building   </TD><TD>  50</TD><TD>TV</TD></TR></TBODY></TABLE><P></P><P>Table2:</P><TABLE><TBODY><TR><TD>Gewerk </TD><TD>PriceREAL  </TD><TD>PRICEFUTURE</TD></TR><TR><TD>Buliding  </TD><TD>350</TD><TD>400</TD></TR><TR><TD>Planning   </TD><TD>250</TD><TD>150</TD></TR></TBODY></TABLE><P></P><P>Taget:</P><P></P><TABLE jive-data-cell="{"color":"#575757","textAlign":"left","padding":"NaN","backgroundColor":"transparent","fontFamily":"arial,helvetica,sans-serif","verticalAlign":"baseline"}" jive-data-header="{"color":"#FFFFFF","backgroundColor":"#6690BC","textAlign":"center","padding":"2"}"><TBODY><TR><TD><STRONG>Gewerk, </STRONG></TD><TD><STRONG>PriceREAL</STRONG>,   </TD><TD><STRONG>PRICEFUTURE</STRONG></TD><TD><STRONG><EM style="text-decoration: underline;"><SPAN style="color: #00ff00; text-decoration: underline;">PriceNEW</SPAN></EM></STRONG></TD></TR><TR><TD>Buliding  </TD><TD>350</TD><TD>400</TD><TD>200</TD></TR><TR><TD>Planning   </TD><TD>250</TD><TD>150</TD><TD>100</TD></TR></TBODY></TABLE><P></P><P>The Target contains the distinct sum() of table1.</P><P>How can I map the distinct data of Table1 to Table 2 ?</P><P></P><P>Thanks for helping.</P><P>CS</P></BODY></HTML> Wed, 16 Mar 2016 15:42:16 GMT https://community.qlik.com/t5/App-Development/Mapping-and-sum/m-p/1087388#M18135 segerchr 2016-03-16T15:42:16Z Re: Mapping and sum() https://community.qlik.com/t5/App-Development/Mapping-and-sum/m-p/1087389#M18136 <HTML><HEAD></HEAD><BODY><P>Answered it here -> <A href="https://community.qlik.com/thread/209729">Mapping load and sum()</A></P></BODY></HTML> Wed, 16 Mar 2016 20:36:37 GMT https://community.qlik.com/t5/App-Development/Mapping-and-sum/m-p/1087389#M18136 sunny_talwar 2016-03-16T20:36:37Z