topic Scenario in QlikView https://community.qlik.com/t5/QlikView/Scenario/m-p/1052430#M353109 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am Having a scenario where i have data in following Format</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl63" height="100" width="64">Plant</TD><TD class="xl63" width="64">Material</TD><TD class="xl63" width="64">Status</TD></TR><TR><TD height="20">A</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">B</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">C</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">D</TD><TD align="right">111</TD><TD>Non Moving</TD></TR><TR><TD height="20">E</TD><TD align="right">111</TD><TD>Slow Moving</TD></TR></TBODY></TABLE><P></P><P>and Have to acheive below table in Front End.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="448"><TBODY><TR><TD class="xl66" height="100" width="64">Plant</TD><TD class="xl67" style="border-left: none;" width="64">Material</TD><TD class="xl67" style="border-left: none;" width="64">Status</TD><TD class="xl67" style="border-left: none;" width="64">Non Moving Status in other Plant</TD><TD class="xl67" style="border-left: none;" width="64">Non Moving Plant in other Plant</TD><TD class="xl67" style="border-left: none;" width="64">Slow Moving Status in other Plant</TD><TD class="xl68" style="border-left: none;" width="64">Slow Moving Plant in other Plant</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">D</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl71" height="21" style="border-top: none;">E</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">111</TD><TD class="xl72" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl72" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl72" style="border-top: none; border-left: none;">D</TD><TD class="xl72" style="border-top: none; border-left: none;">-</TD><TD class="xl73" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE><P></P><P>Thanks in Advance.</P></BODY></HTML> Mon, 29 Feb 2016 17:07:41 GMT bohravanraj 2016-02-29T17:07:41Z Scenario https://community.qlik.com/t5/QlikView/Scenario/m-p/1052430#M353109 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I am Having a scenario where i have data in following Format</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="192"><TBODY><TR><TD class="xl63" height="100" width="64">Plant</TD><TD class="xl63" width="64">Material</TD><TD class="xl63" width="64">Status</TD></TR><TR><TD height="20">A</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">B</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">C</TD><TD align="right">111</TD><TD>Moving</TD></TR><TR><TD height="20">D</TD><TD align="right">111</TD><TD>Non Moving</TD></TR><TR><TD height="20">E</TD><TD align="right">111</TD><TD>Slow Moving</TD></TR></TBODY></TABLE><P></P><P>and Have to acheive below table in Front End.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="448"><TBODY><TR><TD class="xl66" height="100" width="64">Plant</TD><TD class="xl67" style="border-left: none;" width="64">Material</TD><TD class="xl67" style="border-left: none;" width="64">Status</TD><TD class="xl67" style="border-left: none;" width="64">Non Moving Status in other Plant</TD><TD class="xl67" style="border-left: none;" width="64">Non Moving Plant in other Plant</TD><TD class="xl67" style="border-left: none;" width="64">Slow Moving Status in other Plant</TD><TD class="xl68" style="border-left: none;" width="64">Slow Moving Plant in other Plant</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">A</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">B</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">C</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">D</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl69" height="20" style="border-top: none;">D</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">111</TD><TD class="xl65" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">-</TD><TD class="xl65" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl70" style="border-top: none; border-left: none;">E</TD></TR><TR><TD class="xl71" height="21" style="border-top: none;">E</TD><TD align="right" class="xl72" style="border-top: none; border-left: none;">111</TD><TD class="xl72" style="border-top: none; border-left: none;">Slow Moving</TD><TD class="xl72" style="border-top: none; border-left: none;">Non Moving</TD><TD class="xl72" style="border-top: none; border-left: none;">D</TD><TD class="xl72" style="border-top: none; border-left: none;">-</TD><TD class="xl73" style="border-top: none; border-left: none;">-</TD></TR></TBODY></TABLE><P></P><P>Thanks in Advance.</P></BODY></HTML> Mon, 29 Feb 2016 17:07:41 GMT https://community.qlik.com/t5/QlikView/Scenario/m-p/1052430#M353109 bohravanraj 2016-02-29T17:07:41Z