topic MAPPING LOAD in QlikView

topic MAPPING LOAD in QlikView https://community.qlik.com/t5/QlikView/MAPPING-LOAD/m-p/908578#M315499 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I attach herewith my sample data model where the output report is follows</P><P></P><TABLE><TBODY><TR><TD>PAID_MONTH</TD><TD>2015-01</TD><TD>2015-01</TD><TD>2015-05</TD><TD>2015-05</TD></TR><TR><TD>PROV_MONTH</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD></TR><TR><TD>2014-11</TD><TD>150,000</TD><TD>0</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-01</TD><TD>152,100</TD><TD>0</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-02</TD><TD>46,600</TD><TD>241,300</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-04</TD><TD>-</TD><TD>-</TD><TD>50,000</TD><TD>75,000</TD></TR><TR><TD>2015-05</TD><TD>-</TD><TD>-</TD><TD>25,000</TD><TD>0</TD></TR><TR><TD>Total</TD><TD>348,700</TD><TD>241,300</TD><TD>75,000</TD><TD>75,000</TD></TR></TBODY></TABLE><P></P><P>But the report I want should look like as follows  Pls help me</P><P></P><TABLE><TBODY><TR><TD>PAID_MONTH</TD><TD>2015-01</TD><TD>2015-01</TD><TD>2015-02</TD><TD>2015-02</TD><TD>2015-05</TD><TD>2015-05</TD></TR><TR><TD>PROV_MONTH</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD></TR><TR><TD>2014-11</TD><TD>150,000</TD><TD>0</TD><TD></TD><TD></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-01</TD><TD>152,100</TD><TD><SPAN style="color: #ff0000;">241,300</SPAN></TD><TD></TD><TD></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-02</TD><TD>46,600</TD><TD></TD><TD><SPAN style="color: #ff0000;">46600</SPAN></TD><TD><SPAN style="color: #ff0000;">46600</SPAN></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-04</TD><TD>-</TD><TD>-</TD><TD></TD><TD></TD><TD>50,000</TD><TD></TD></TR><TR><TD>2015-05</TD><TD>-</TD><TD>-</TD><TD></TD><TD></TD><TD>25,000</TD><TD></TD></TR><TR><TD>Total</TD><TD>348,700</TD><TD>241,300</TD><TD>46600</TD><TD>46600</TD><TD>75,000</TD><TD><SPAN style="color: #ff0000;">75,000</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 21 Jul 2015 16:01:29 GMT upaliwije 2015-07-21T16:01:29Z MAPPING LOAD https://community.qlik.com/t5/QlikView/MAPPING-LOAD/m-p/908578#M315499 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I attach herewith my sample data model where the output report is follows</P><P></P><TABLE><TBODY><TR><TD>PAID_MONTH</TD><TD>2015-01</TD><TD>2015-01</TD><TD>2015-05</TD><TD>2015-05</TD></TR><TR><TD>PROV_MONTH</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD></TR><TR><TD>2014-11</TD><TD>150,000</TD><TD>0</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-01</TD><TD>152,100</TD><TD>0</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-02</TD><TD>46,600</TD><TD>241,300</TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-04</TD><TD>-</TD><TD>-</TD><TD>50,000</TD><TD>75,000</TD></TR><TR><TD>2015-05</TD><TD>-</TD><TD>-</TD><TD>25,000</TD><TD>0</TD></TR><TR><TD>Total</TD><TD>348,700</TD><TD>241,300</TD><TD>75,000</TD><TD>75,000</TD></TR></TBODY></TABLE><P></P><P>But the report I want should look like as follows  Pls help me</P><P></P><TABLE><TBODY><TR><TD>PAID_MONTH</TD><TD>2015-01</TD><TD>2015-01</TD><TD>2015-02</TD><TD>2015-02</TD><TD>2015-05</TD><TD>2015-05</TD></TR><TR><TD>PROV_MONTH</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD><TD>sum(PROVISION_AMOUNT)</TD><TD>sum(PAID_AMOUNT)</TD></TR><TR><TD>2014-11</TD><TD>150,000</TD><TD>0</TD><TD></TD><TD></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-01</TD><TD>152,100</TD><TD><SPAN style="color: #ff0000;">241,300</SPAN></TD><TD></TD><TD></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-02</TD><TD>46,600</TD><TD></TD><TD><SPAN style="color: #ff0000;">46600</SPAN></TD><TD><SPAN style="color: #ff0000;">46600</SPAN></TD><TD>-</TD><TD>-</TD></TR><TR><TD>2015-04</TD><TD>-</TD><TD>-</TD><TD></TD><TD></TD><TD>50,000</TD><TD></TD></TR><TR><TD>2015-05</TD><TD>-</TD><TD>-</TD><TD></TD><TD></TD><TD>25,000</TD><TD></TD></TR><TR><TD>Total</TD><TD>348,700</TD><TD>241,300</TD><TD>46600</TD><TD>46600</TD><TD>75,000</TD><TD><SPAN style="color: #ff0000;">75,000</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 21 Jul 2015 16:01:29 GMT https://community.qlik.com/t5/QlikView/MAPPING-LOAD/m-p/908578#M315499 upaliwije 2015-07-21T16:01:29Z