topic Re: Ayuda Set Analysis in App Development https://community.qlik.com/t5/App-Development/Ayuda-Set-Analysis/m-p/2429563#M96441 <P>Try this</P> <P>Table1:<BR />LOAD * INLINE [<BR />Period, Product, Monto<BR />202402, ID01, 117.04<BR />202402, ID02, 82.261<BR />202402, ID03, 144.883<BR />202402, ID04, 116.472<BR />202402, ID05, 55.655<BR />202402, ID06, 132.969<BR />202402, ID07, 112.034<BR />202402, ID08, 117.04<BR />202402, ID09, 82.261<BR />202402, ID10, 144.883<BR />202402, ID11, 116.472<BR />202402, ID12, 55.655<BR />202402, ID13, 132.969<BR />202402, ID14, 112.034<BR />];</P> <P>MappingMonto:<BR />Mapping LOAD Product, Monto<BR />Resident Table1;</P> <P>Drop table Table1;</P> <P>Table2:<BR />LOAD *, ApplyMap('MappingMonto', [Product Consecuent], '') as Monto;<BR />LOAD * INLINE [<BR />Period, product, Product Consecuent<BR />202402, ID01, ID03<BR />202402, ID01, ID04<BR />202402, ID01, ID05<BR />202402, ID01, ID06<BR />202402, ID01, ID07<BR />202402, ID06, ID12<BR />202402, ID06, ID13<BR />202402, ID06, ID14<BR />];</P> Tue, 12 Mar 2024 06:07:31 GMT Nagaraju_KCS 2024-03-12T06:07:31Z Ayuda Set Analysis https://community.qlik.com/t5/App-Development/Ayuda-Set-Analysis/m-p/2429500#M96436 <P>Hola!</P> <P>Se tienen 2 tablas 'Tbl_Ventas' y 'Tbl_Consecuente' las cuales están relacionadas a través del Periodo y el Producto</P> <P>Se requiere crear una tercera tabla 'Tbl_Final' que contenga la venta de los productos de la tabla&nbsp;'Tbl_Consecuente' y la venta de los productos de la columna 'Producto Consecuente' de esta misma tabla</P> <P>En la imagen se muestra la necesidad</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="oscar_olaya_0-1710190175336.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/161745i5FD9ED0EF7BCF7CB/image-size/medium?v=v2&amp;px=400" role="button" title="oscar_olaya_0-1710190175336.png" alt="oscar_olaya_0-1710190175336.png" /></span></P> <P>&nbsp;</P> <P>Gracias</P> Mon, 11 Mar 2024 20:49:48 GMT https://community.qlik.com/t5/App-Development/Ayuda-Set-Analysis/m-p/2429500#M96436 oscar_olaya 2024-03-11T20:49:48Z Re: Ayuda Set Analysis https://community.qlik.com/t5/App-Development/Ayuda-Set-Analysis/m-p/2429563#M96441 <P>Try this</P> <P>Table1:<BR />LOAD * INLINE [<BR />Period, Product, Monto<BR />202402, ID01, 117.04<BR />202402, ID02, 82.261<BR />202402, ID03, 144.883<BR />202402, ID04, 116.472<BR />202402, ID05, 55.655<BR />202402, ID06, 132.969<BR />202402, ID07, 112.034<BR />202402, ID08, 117.04<BR />202402, ID09, 82.261<BR />202402, ID10, 144.883<BR />202402, ID11, 116.472<BR />202402, ID12, 55.655<BR />202402, ID13, 132.969<BR />202402, ID14, 112.034<BR />];</P> <P>MappingMonto:<BR />Mapping LOAD Product, Monto<BR />Resident Table1;</P> <P>Drop table Table1;</P> <P>Table2:<BR />LOAD *, ApplyMap('MappingMonto', [Product Consecuent], '') as Monto;<BR />LOAD * INLINE [<BR />Period, product, Product Consecuent<BR />202402, ID01, ID03<BR />202402, ID01, ID04<BR />202402, ID01, ID05<BR />202402, ID01, ID06<BR />202402, ID01, ID07<BR />202402, ID06, ID12<BR />202402, ID06, ID13<BR />202402, ID06, ID14<BR />];</P> Tue, 12 Mar 2024 06:07:31 GMT https://community.qlik.com/t5/App-Development/Ayuda-Set-Analysis/m-p/2429563#M96441 Nagaraju_KCS 2024-03-12T06:07:31Z