topic Re: Apply Map function in qlik View/Sense in QlikView https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110189#M757393 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d;">May be I am confuse to get the output, but It would be great help if you could suggest me how to get this output –</SPAN></P><P><SPAN style="color: #0070c0;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">month</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="143"><P><STRONG style="color: #0070c0; font-size: 10.0pt; font-family: inherit;">Product_Short_Name</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">State</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">sales qty</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">forecast qty</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">Mar</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MSP</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">TELANGANA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">5.4</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">6</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">june</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MDP</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MAHARASHTRA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">20</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">july</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">LG</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">KERELA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">15</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">aug</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">DMH</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">JHARKHAND</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">4</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Out of these three tables :-</SPAN></P><P><SPAN style="color: #1f497d;">Table1</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="136"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Forecast</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Month/DATE</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product code</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Forecst_Qty</STRONG><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">.</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">STATE/COUNTRY</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Product_Short_Name</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/06/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0593E00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">6</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">TELANGANA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/07/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I1211T00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">20</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAHARASHTRA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/08/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I2047T00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">15</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">KERELA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/04/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">H4815C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">4</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">JHARKHAND</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Table2</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="113"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">SALES</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Month/DATE</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product/IM_CODE</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Sales_Qty</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit;">STATE/COUNTRY</SPAN></P></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0192C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">21/06/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP00000003</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">5.4</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">TELANGANA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">03/07/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAHARASHTRA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">09/08/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG000004</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">KERELA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">14/04/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">JHARKHAND</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Table3</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="156"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product/IM_CODE</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product code</STRONG></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0192C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP00000003</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">339000</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG000004</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">370004</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">368000</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P></BODY></HTML> Tue, 11 Sep 2018 04:19:30 GMT cruzo008 2018-09-11T04:19:30Z Apply Map function in qlik View/Sense https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110187#M757390 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi All,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i want to a table with&nbsp; <STRONG>"STATE/COUNTRY" wise "Product_Short_Name" wise monthly "Sales_Qty"&nbsp; Vs.&nbsp; "Forecst_Qty"</STRONG> .</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">to achieve this my data is as follows</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 757px;"><TBODY><TR><TD height="19" width="123">Forecast</TD><TD></TD></TR><TR><TD class="xl70" height="19">Month/DATE</TD><TD class="xl73"><STRONG>Product code</STRONG></TD><TD class="xl73"><STRONG>CICS/Party CICS</STRONG></TD><TD class="xl65"><STRONG>Party_Code/PARTY_NO</STRONG></TD><TD class="xl66"><SPAN style="font-size: 13.3333px;"><STRONG>F</STRONG></SPAN><SPAN style="font-size: 13.3333px;"><STRONG>orecst_Qty</STRONG></SPAN>.</TD><TD class="xl66">STATE/COUNTRY</TD><TD>Product_Short_Name</TD></TR><TR><TD class="xl71" height="19">01/06/2018 12:00:00 AM</TD><TD class="xl72">179006</TD><TD class="xl72" style="border-left: none;">I0593E00</TD><TD class="xl72" style="border-left: none;">M0214</TD><TD class="xl67" style="border-left: none;">6</TD><TD class="xl68">TELANGANA</TD><TD class="xl69">MSP</TD></TR><TR><TD class="xl71" height="19">01/07/2018 12:00:00 AM</TD><TD class="xl72" style="border-top: none;">179006</TD><TD class="xl72" style="border-top: none; border-left: none;">I1211T00</TD><TD class="xl72" style="border-top: none; border-left: none;">R0096</TD><TD class="xl67" style="border-top: none; border-left: none;">20</TD><TD class="xl68">MAHARASHTRA</TD><TD class="xl69">MDP</TD></TR><TR><TD class="xl71" height="19">01/08/2018 12:00:00 AM</TD><TD class="xl72" style="border-top: none;">179006</TD><TD class="xl72" style="border-top: none; border-left: none;">I2047T00</TD><TD class="xl72" style="border-top: none; border-left: none;">L0043</TD><TD class="xl67" style="border-top: none; border-left: none;">15</TD><TD class="xl68"><SPAN style="font-size: 13.3333px;">KERELA</SPAN></TD><TD class="xl69">LG</TD></TR><TR><TD class="xl71" height="19">01/04/2018 12:00:00 AM</TD><TD class="xl72" style="border-top: none;">179006</TD><TD class="xl72" style="border-top: none; border-left: none;">H4815C00</TD><TD class="xl72" style="border-top: none; border-left: none;">M0254</TD><TD class="xl67" style="border-top: none; border-left: none;">4</TD><TD class="xl68"><SPAN style="font-size: 13.3333px;">JHARKHAND</SPAN></TD><TD class="xl69"><P>DMH</P></TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="159" style="width: 802px; height: 156px;"><TBODY><TR><TD class="xl67" height="19" width="62">SALES</TD><TD></TD></TR><TR><TD class="xl72"><STRONG>CICS/Party CICS</STRONG></TD><TD class="xl69">Month/DATE</TD><TD class="xl68"><STRONG>Product/IM_CODE</STRONG></TD><TD class="xl72"><STRONG>Party_Code/PARTY_NO</STRONG></TD><TD class="xl68"><SPAN style="font-size: 13.3333px;"><STRONG>S</STRONG></SPAN><SPAN style="font-size: 13.3333px;"><STRONG>ales_Qty</STRONG></SPAN></TD><TD class="xl68"><TABLE border="0" cellpadding="0" cellspacing="0" style="font-size: 13.3333px;"><TBODY><TR><TD class="xl66">STATE/COUNTRY</TD></TR></TBODY></TABLE></TD></TR><TR><TD class="xl67">I0192C00</TD><TD class="xl70">21/06/2018 12:00:00 AM</TD><TD class="xl66">MSP00000003</TD><TD class="xl71">M0214</TD><TD class="xl67">5.4</TD><TD class="xl65">TELANGANA</TD></TR><TR><TD class="xl67">I0359Y00</TD><TD class="xl70">03/07/2018 12:00:00 AM</TD><TD class="xl66">MDP00001</TD><TD class="xl71" style="border-top: none;">R0096</TD><TD class="xl67">9.9</TD><TD class="xl65">MAHARASHTRA</TD></TR><TR><TD class="xl67">I0359Y00</TD><TD class="xl70">09/08/2018 12:00:00 AM</TD><TD class="xl66">LG000004</TD><TD class="xl71" style="border-top: none;">L0043</TD><TD class="xl67">9.9</TD><TD class="xl65">KERELA</TD></TR><TR><TD class="xl67">I0359Y00</TD><TD class="xl70">14/04/2018 12:00:00 AM</TD><TD class="xl66">DMH00001</TD><TD class="xl71" style="border-top: none;">M0254</TD><TD class="xl67">9</TD><TD class="xl67">JHARKHAND</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="139" style="width: 788px; height: 115px;"><TBODY><TR><TD class="xl66" height="19" width="142">MAP</TD><TD></TD></TR><TR><TD class="xl68" height="19"><STRONG>Party_Code/PARTY_NO</STRONG></TD><TD class="xl68"><STRONG>CICS/Party CICS</STRONG></TD><TD class="xl68"><STRONG>Product/IM_CODE</STRONG></TD><TD class="xl68"><STRONG>Product code</STRONG></TD></TR><TR><TD class="xl67" height="19">M0214</TD><TD class="xl66">I0192C00</TD><TD class="xl65">MSP00000003</TD><TD class="xl65">179006</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">R0096</TD><TD class="xl66">I0359Y00</TD><TD class="xl65">MDP00001</TD><TD class="xl65">339000</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">L0043</TD><TD class="xl66">I0359Y00</TD><TD class="xl65">LG000004</TD><TD class="xl65">370004</TD></TR><TR><TD class="xl67" height="19" style="border-top: none;">M0254</TD><TD class="xl66">I0359Y00</TD><TD class="xl65">DMH00001</TD><TD class="xl65">368000</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i dont know how to map them, can anyone help me on script part?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110187#M757390 cruzo008 2020-11-25T16:16:04Z Re: Apply Map function in qlik View/Sense https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110188#M757391 <HTML><HEAD></HEAD><BODY><P>May be try this? Rename the fields in Sales table accordingly. And i used Party_Code/PARTY_No as joining key. </P><P></P><P>Forecast:</P><P>LOAD [Month/DATE], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Product code], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [CICS/Party CICS], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Party_Code/PARTY_NO], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Forecst_Qty., </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [STATE/COUNTRY], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Product_Short_Name</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="313441" data-objecttype="1" href="https://community.qlik.com/thread/313441">https://community.qlik.com/thread/313441</A><SPAN>]</SPAN></P><P>(html, utf8, embedded labels, table is @1, filters(</P><P>Remove(Row, Pos(Top, 1))</P><P>));</P><P></P><P></P><P></P><P></P><P>Sales:</P><P>LOAD [CICS/Party CICS] AS SalesPartyCICS, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Month/DATE] AS SalesDate, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Product/IM_CODE] AS SalesProdIMCode, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Party_Code/PARTY_NO], </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sales_Qty, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; F6 AS Sales_St_Country</P><P>FROM</P><P><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="313441" data-objecttype="1" href="https://community.qlik.com/thread/313441">https://community.qlik.com/thread/313441</A><SPAN>]</SPAN></P><P>(html, utf8, embedded labels, table is @3, filters(</P><P>Remove(Row, Pos(Top, 1))</P><P>));</P></BODY></HTML> Mon, 10 Sep 2018 16:55:32 GMT https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110188#M757391 vishsaggi 2018-09-10T16:55:32Z Re: Apply Map function in qlik View/Sense https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110189#M757393 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #1f497d;">May be I am confuse to get the output, but It would be great help if you could suggest me how to get this output –</SPAN></P><P><SPAN style="color: #0070c0;"> </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">month</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="143"><P><STRONG style="color: #0070c0; font-size: 10.0pt; font-family: inherit;">Product_Short_Name</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">State</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">sales qty</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><STRONG style="color: #0070c0;">forecast qty</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">Mar</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MSP</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">TELANGANA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">5.4</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">6</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">june</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MDP</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">MAHARASHTRA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">20</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">july</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">LG</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">KERELA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">15</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="color: #0070c0;">aug</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="143"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">DMH</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="118"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">JHARKHAND</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">9</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="79"><P align="center" style="text-align: center;"><SPAN style="font-size: 10.0pt; font-family: inherit; color: #0070c0;">4</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Out of these three tables :-</SPAN></P><P><SPAN style="color: #1f497d;">Table1</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="136"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Forecast</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Month/DATE</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product code</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Forecst_Qty</STRONG><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">.</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">STATE/COUNTRY</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Product_Short_Name</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/06/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0593E00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">6</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">TELANGANA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/07/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I1211T00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">20</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAHARASHTRA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/08/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I2047T00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">15</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">KERELA</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">01/04/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">H4815C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">4</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">JHARKHAND</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Table2</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="113"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">SALES</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">Month/DATE</SPAN></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product/IM_CODE</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Sales_Qty</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit;">STATE/COUNTRY</SPAN></P></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0192C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">21/06/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP00000003</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">5.4</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">TELANGANA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">03/07/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAHARASHTRA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">09/08/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG000004</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><OL style="list-style-type: decimal;"><LI><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9.9</SPAN></LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">KERELA</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">14/04/2018 12:00:00 AM</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">9</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">JHARKHAND</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P><P><SPAN style="color: #1f497d;">Table3</SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="background: white;" width="0"><TBODY><TR><TD style="border: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom" width="156"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MAP</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Party_Code/PARTY_NO</STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">CICS/Party CICS</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product/IM_CODE</STRONG></P></TD><TD style="border: solid black 1.0pt; border-left: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><STRONG style="color: #3d3d3d; font-size: 10.0pt; font-family: inherit;">Product code</STRONG></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0214</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0192C00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MSP00000003</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">179006</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">R0096</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">MDP00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">339000</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">L0043</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">LG000004</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">370004</SPAN></P></TD></TR><TR><TD style="border: solid black 1.0pt; border-top: none; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">M0254</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">I0359Y00</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">DMH00001</SPAN></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid black 1.0pt; border-right: solid black 1.0pt; padding: 1.5pt 3.0pt 1.5pt 3.0pt;" valign="bottom"><P><SPAN style="font-size: 10.0pt; font-family: inherit; color: #3d3d3d;">368000</SPAN></P></TD></TR></TBODY></TABLE><P><SPAN style="color: #1f497d;"> </SPAN></P></BODY></HTML> Tue, 11 Sep 2018 04:19:30 GMT https://community.qlik.com/t5/QlikView/Apply-Map-function-in-qlik-View-Sense/m-p/110189#M757393 cruzo008 2018-09-11T04:19:30Z