topic Scripting in back end in QlikView https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719197#M671222 <HTML><HEAD></HEAD><BODY><P>hi QVs,</P><P>I have a table like this</P><P></P><P>At Commission 2% it should take "5999" instead of "105999" , how to do that ?</P><P></P><P>-lohi</P></BODY></HTML> Wed, 17 Sep 2014 10:33:22 GMT 2014-09-17T10:33:22Z Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719197#M671222 <HTML><HEAD></HEAD><BODY><P>hi QVs,</P><P>I have a table like this</P><P></P><P>At Commission 2% it should take "5999" instead of "105999" , how to do that ?</P><P></P><P>-lohi</P></BODY></HTML> Wed, 17 Sep 2014 10:33:22 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719197#M671222 2014-09-17T10:33:22Z Re: Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719198#M671223 <HTML><HEAD></HEAD><BODY><P>could you make it little more clear because in the image i do see 2.0% but u have mentioned as 0.2%.so, do provide an sample qvw app</P></BODY></HTML> Wed, 17 Sep 2014 10:36:41 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719198#M671223 2014-09-17T10:36:41Z Re: Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719199#M671224 <HTML><HEAD></HEAD><BODY><P>ya bhanu , </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">At Commission 2% it should take "5999" instead of "105999" , how to do that ?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">-lohi<BR /></SPAN></P></BODY></HTML> Wed, 17 Sep 2014 10:38:07 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719199#M671224 2014-09-17T10:38:07Z Re: Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719200#M671225 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-2380">QlikCommunity Tip: How to get answers to your post?</A></P></BODY></HTML> Wed, 17 Sep 2014 10:41:33 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719200#M671225 tresB 2014-09-17T10:41:33Z Re: Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719201#M671226 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try Something like this:</P><P>If(Commission='2%','5999',CumulativeSum)</P><P><BR />You can use this in Script or in Expression.</P><P></P><P>Regards</P><P>Aviral Nag</P></BODY></HTML> Wed, 17 Sep 2014 10:43:50 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719201#M671226 aveeeeeee7en 2014-09-17T10:43:50Z Re: Re: Scripting in back end https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719202#M671227 <HTML><HEAD></HEAD><BODY><P>hi aviral ,</P><P></P><P>Txs for reply ,</P><P></P><P>But it taking all 2% =5999 form there it shoud be cumilative sum .</P></BODY></HTML> Wed, 17 Sep 2014 10:53:29 GMT https://community.qlik.com/t5/QlikView/Scripting-in-back-end/m-p/719202#M671227 2014-09-17T10:53:29Z