topic Prevous value based different Column in QlikView

topic Prevous value based different Column in QlikView https://community.qlik.com/t5/QlikView/Prevous-value-based-different-Column/m-p/698948#M673953 <HTML><HEAD></HEAD><BODY><P><BR />Dear all,</P><P></P><P>     i want to reduce stock value based on previous location and Item</P><P></P><P><STRONG>Find Below My Input Data :</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 384px;"><TBODY><TR><TD class="xl66" height="20" width="64"><STRONG>Location</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Item</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>LineID</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Days</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Req</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Available</STRONG></TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">46</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">55</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">43</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">34</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR></TBODY></TABLE><P></P><P>I want this Output</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 448px;"><TBODY><TR><TD class="xl66" height="20" width="64"><STRONG>Location</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Item</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>LineID</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Days</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Req</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Available</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>output</STRONG></TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">46</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">31</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">30</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">55</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">43</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">34</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">0</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">-1</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 01 Aug 2014 13:58:29 GMT pandiarajan 2014-08-01T13:58:29Z Prevous value based different Column https://community.qlik.com/t5/QlikView/Prevous-value-based-different-Column/m-p/698948#M673953 <HTML><HEAD></HEAD><BODY><P><BR />Dear all,</P><P></P><P>     i want to reduce stock value based on previous location and Item</P><P></P><P><STRONG>Find Below My Input Data :</STRONG></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 384px;"><TBODY><TR><TD class="xl66" height="20" width="64"><STRONG>Location</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Item</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>LineID</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Days</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Req</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Available</STRONG></TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">46</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">55</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">43</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">34</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD></TR></TBODY></TABLE><P></P><P>I want this Output</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 448px;"><TBODY><TR><TD class="xl66" height="20" width="64"><STRONG>Location</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Item</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>LineID</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Days</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Req</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>Available</STRONG></TD><TD class="xl66" style="border-left: medium none;" width="64"><STRONG>output</STRONG></TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">46</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">31</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">XXX</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line2</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">32</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">30</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">55</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line4</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">43</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">40</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">34</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">2</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line7</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">23</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line8</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">0</TD></TR><TR><TD class="xl65" height="20" style="border-top: medium none;">YYY</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">ABC</TD><TD class="xl65" style="border-left: medium none; border-top: medium none;">Line9</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">6</TD><TD align="right" class="xl65" style="border-left: medium none; border-top: medium none;">-1</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 01 Aug 2014 13:58:29 GMT https://community.qlik.com/t5/QlikView/Prevous-value-based-different-Column/m-p/698948#M673953 pandiarajan 2014-08-01T13:58:29Z