topic Replace values ​​without knowing the order? in QlikView https://community.qlik.com/t5/QlikView/Replace-values-without-knowing-the-order/m-p/400555#M149063 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">nesecito</SPAN> <SPAN class="hps">replace</SPAN> <SPAN class="hps">a value</SPAN> <SPAN class="hps">in a field</SPAN> <SPAN class="hps">other than I</SPAN> <SPAN class="hps">want</SPAN>, <SPAN class="hps">cualquiera.ejmp</SPAN></P><P></P><P></P><P></P><P></P><P></P><P> <SPAN class="hps">Data</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN><SPAN class="hps">Cost&nbsp; </SPAN> <SPAN class="hps">&nbsp; </SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">1000</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP&nbsp;&nbsp; </SPAN> <SPAN class="hps">2000</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP&nbsp;&nbsp; </SPAN> <SPAN class="hps">1000</SPAN></P><P></P><P> <SPAN class="hps">MY</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails&nbsp; </SPAN> <SPAN class="hps">0.60</SPAN></P><P></P><P> <SPAN class="hps">MY</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">BAND&nbsp; </SPAN> <SPAN class="hps">0.70</SPAN></P><P></P><P> <SPAN class="hps">My&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN class="hps">0.15</SPAN></P><P></P><P></P><P></P><P></P><P></P><P> <SPAN class="hps">Pivot</SPAN> <SPAN class="hps">Table</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">Rgistro</SPAN> <SPAN class="hps">Type&nbsp;&nbsp;&nbsp; Cost</SPAN></P><P></P><P> <SPAN class="hps">Meat&nbsp;&nbsp; </SPAN> <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN class="hps">0.60</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">BAND</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.70</SPAN></P><P></P><P> <SPAN class="hps">MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; role</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.15</SPAN></P><P></P><P></P><P></P><P> <SPAN class="hps">Time</SPAN> <SPAN class="hps">Role</SPAN> <SPAN class="hps">want</SPAN> <SPAN class="hps">I have no</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">of 0.15</SPAN> <SPAN class="hps">assuming that</SPAN> <SPAN class="hps">is the sum</SPAN>, I <SPAN class="hps">have</SPAN> <SPAN class="hps">the same</SPAN> <SPAN class="hps">MP Cost</SPAN> <SPAN class="hps">Meat</SPAN>.</P><P></P><P> <SPAN class="hps">Pivot</SPAN> <SPAN class="hps">Table</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">Rgistro&nbsp;&nbsp; </SPAN> <SPAN class="hps">Type&nbsp;&nbsp;&nbsp;&nbsp; Cost</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.60</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps"><STRONG style=": ; color: #333333; text-decoration: underline;"><SPAN class="hps"> MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; role</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></STRONG></SPAN></P><P></P><P> <SPAN class="hps">MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">BAND</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.70</SPAN></P></BODY></HTML> Wed, 12 Sep 2012 13:18:01 GMT 2012-09-12T13:18:01Z Replace values ​​without knowing the order? https://community.qlik.com/t5/QlikView/Replace-values-without-knowing-the-order/m-p/400555#M149063 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">nesecito</SPAN> <SPAN class="hps">replace</SPAN> <SPAN class="hps">a value</SPAN> <SPAN class="hps">in a field</SPAN> <SPAN class="hps">other than I</SPAN> <SPAN class="hps">want</SPAN>, <SPAN class="hps">cualquiera.ejmp</SPAN></P><P></P><P></P><P></P><P></P><P></P><P> <SPAN class="hps">Data</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></SPAN><SPAN class="hps">Cost&nbsp; </SPAN> <SPAN class="hps">&nbsp; </SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">1000</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP&nbsp;&nbsp; </SPAN> <SPAN class="hps">2000</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP&nbsp;&nbsp; </SPAN> <SPAN class="hps">1000</SPAN></P><P></P><P> <SPAN class="hps">MY</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails&nbsp; </SPAN> <SPAN class="hps">0.60</SPAN></P><P></P><P> <SPAN class="hps">MY</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">BAND&nbsp; </SPAN> <SPAN class="hps">0.70</SPAN></P><P></P><P> <SPAN class="hps">My&nbsp;&nbsp;&nbsp;&nbsp; role&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN class="hps">0.15</SPAN></P><P></P><P></P><P></P><P></P><P></P><P> <SPAN class="hps">Pivot</SPAN> <SPAN class="hps">Table</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">Rgistro</SPAN> <SPAN class="hps">Type&nbsp;&nbsp;&nbsp; Cost</SPAN></P><P></P><P> <SPAN class="hps">Meat&nbsp;&nbsp; </SPAN> <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN class="hps">0.60</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">BAND</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.70</SPAN></P><P></P><P> <SPAN class="hps">MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; role</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.15</SPAN></P><P></P><P></P><P></P><P> <SPAN class="hps">Time</SPAN> <SPAN class="hps">Role</SPAN> <SPAN class="hps">want</SPAN> <SPAN class="hps">I have no</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">of 0.15</SPAN> <SPAN class="hps">assuming that</SPAN> <SPAN class="hps">is the sum</SPAN>, I <SPAN class="hps">have</SPAN> <SPAN class="hps">the same</SPAN> <SPAN class="hps">MP Cost</SPAN> <SPAN class="hps">Meat</SPAN>.</P><P></P><P> <SPAN class="hps">Pivot</SPAN> <SPAN class="hps">Table</SPAN>:</P><P></P><P></P><P></P><P> <SPAN class="hps">Rgistro&nbsp;&nbsp; </SPAN> <SPAN class="hps">Type&nbsp;&nbsp;&nbsp;&nbsp; Cost</SPAN></P><P></P><P> <SPAN class="hps">Meat</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">MP</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></P><P></P><P> <SPAN class="hps">MI</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Nails</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.60</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps"><STRONG style=": ; color: #333333; text-decoration: underline;"><SPAN class="hps"> MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; role</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">4000</SPAN></STRONG></SPAN></P><P></P><P> <SPAN class="hps">MI&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN class="hps">BAND</SPAN>&nbsp;&nbsp;&nbsp; <SPAN class="hps">0.70</SPAN></P></BODY></HTML> Wed, 12 Sep 2012 13:18:01 GMT https://community.qlik.com/t5/QlikView/Replace-values-without-knowing-the-order/m-p/400555#M149063 2012-09-12T13:18:01Z