topic Re Distribution Tool in QlikView https://community.qlik.com/t5/QlikView/Re-Distribution-Tool/m-p/86479#M14180 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Actually i need to make a Re Distribution tool which should tell that Product which is having excess stock in one location can be distributed to other location.</P><P></P><P>My basic data is like this below.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BRANCH</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRODUCT</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">REQUIRED_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">AVAILABLE_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">EXCESS_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">SHORT_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;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">100</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">180</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">150</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">110</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">40</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">150</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">130</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">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;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">70</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">10</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>From this data i need to make a report like this below.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD colspan="3" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="244"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">DISTRIBUTE TO</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BRANCH</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRODUCT</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">EXCESS_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="65"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR2</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="85"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR3</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR4</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="65"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">40</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="85"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">10</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Can anybody help please.</P><P></P><P>Regards,</P><P>Ajith</P></BODY></HTML> Wed, 27 Jun 2018 10:07:33 GMT ajithsachin 2018-06-27T10:07:33Z Re Distribution Tool https://community.qlik.com/t5/QlikView/Re-Distribution-Tool/m-p/86479#M14180 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Actually i need to make a Re Distribution tool which should tell that Product which is having excess stock in one location can be distributed to other location.</P><P></P><P>My basic data is like this below.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BRANCH</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRODUCT</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">REQUIRED_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">AVAILABLE_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">EXCESS_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">SHORT_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;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">100</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">180</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">150</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">110</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">40</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">150</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">130</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">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;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="120"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="126"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">70</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">0</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="96"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">10</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>From this data i need to make a report like this below.</P><TABLE border="0" cellpadding="0" cellspacing="0" style="padding: 0 5.4pt 0 5.4pt;" width="0"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"> </STRONG></P></TD><TD colspan="3" nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="244"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">DISTRIBUTE TO</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BRANCH</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRODUCT</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">EXCESS_QTY</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="65"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR2</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="85"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR3</STRONG></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; background: #FFD966; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><STRONG style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR4</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">BR1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="80"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">PRD1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="103"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">80</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="65"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">40</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="85"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">20</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="93"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="font-size: 10.0pt; font-family: 'Arial',sans-serif;">10</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P>Can anybody help please.</P><P></P><P>Regards,</P><P>Ajith</P></BODY></HTML> Wed, 27 Jun 2018 10:07:33 GMT https://community.qlik.com/t5/QlikView/Re-Distribution-Tool/m-p/86479#M14180 ajithsachin 2018-06-27T10:07:33Z