topic Calculation of commissions in QlikView https://community.qlik.com/t5/QlikView/Calculation-of-commissions/m-p/450423#M168062 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hi</SPAN> <SPAN class="hps">all</SPAN><SPAN>,</SPAN><BR /><SPAN class="hps">No</SPAN> <SPAN class="hps">such</SPAN> <SPAN class="hps">approach this</SPAN> <SPAN class="hps">solution</SPAN><SPAN>.</SPAN> <SPAN class="hps">Please</SPAN> <SPAN class="hps">can you help?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">First</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">an array</SPAN> <SPAN class="hps">of</SPAN> commissions<SPAN>.</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><IMG __jive_id="25383" class="jive-image" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/25383_Captura.PNG" /><IMG __jive_id="25384" class="jive-image" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/25384_Captura.PNG" /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">Second</SPAN> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">discount value "% Dto1"</SPAN> <SPAN class="hps">applied</SPAN> <SPAN class="hps">at</SPAN> <SPAN class="hps">invoice</SPAN> <SPAN class="hps">lines</SPAN><SPAN>,</SPAN> <SPAN class="hps">which</SPAN> <SPAN class="hps">I</SPAN> must <SPAN class="hps">compare to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps atn">fileds "</SPAN><SPAN>PorMayor</SPAN><SPAN>"</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps atn">"</SPAN><SPAN>PorMenor</SPAN><SPAN>" to</SPAN> <SPAN class="hps">the end</SPAN><SPAN>, apply</SPAN> <SPAN class="hps atn">the "</SPAN><SPAN>Comisión</SPAN><SPAN>" field</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">I do it in</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">script</SPAN><SPAN>?</SPAN> <SPAN class="hps">better</SPAN> <SPAN class="hps">in the Document</SPAN><SPAN>?</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><SPAN lang="en"></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 20 Nov 2012 12:29:29 GMT 2012-11-20T12:29:29Z Calculation of commissions https://community.qlik.com/t5/QlikView/Calculation-of-commissions/m-p/450423#M168062 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">Hi</SPAN> <SPAN class="hps">all</SPAN><SPAN>,</SPAN><BR /><SPAN class="hps">No</SPAN> <SPAN class="hps">such</SPAN> <SPAN class="hps">approach this</SPAN> <SPAN class="hps">solution</SPAN><SPAN>.</SPAN> <SPAN class="hps">Please</SPAN> <SPAN class="hps">can you help?</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">First</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">an array</SPAN> <SPAN class="hps">of</SPAN> commissions<SPAN>.</SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><IMG __jive_id="25383" class="jive-image" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/25383_Captura.PNG" /><IMG __jive_id="25384" class="jive-image" alt="Captura.PNG" src="https://community.qlik.com/legacyfs/online/25384_Captura.PNG" /></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">Second</SPAN> <SPAN class="hps">I have a</SPAN> <SPAN class="hps">discount value "% Dto1"</SPAN> <SPAN class="hps">applied</SPAN> <SPAN class="hps">at</SPAN> <SPAN class="hps">invoice</SPAN> <SPAN class="hps">lines</SPAN><SPAN>,</SPAN> <SPAN class="hps">which</SPAN> <SPAN class="hps">I</SPAN> must <SPAN class="hps">compare to</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps atn">fileds "</SPAN><SPAN>PorMayor</SPAN><SPAN>"</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps atn">"</SPAN><SPAN>PorMenor</SPAN><SPAN>" to</SPAN> <SPAN class="hps">the end</SPAN><SPAN>, apply</SPAN> <SPAN class="hps atn">the "</SPAN><SPAN>Comisión</SPAN><SPAN>" field</SPAN><SPAN>.</SPAN><BR /><SPAN class="hps">I do it in</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">script</SPAN><SPAN>?</SPAN> <SPAN class="hps">better</SPAN> <SPAN class="hps">in the Document</SPAN><SPAN>?</SPAN></SPAN></SPAN></SPAN></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><SPAN class="short_text" lang="en"><SPAN><SPAN lang="en"></SPAN></SPAN></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 20 Nov 2012 12:29:29 GMT https://community.qlik.com/t5/QlikView/Calculation-of-commissions/m-p/450423#M168062 2012-11-20T12:29:29Z