topic Caluclation Script in QlikView https://community.qlik.com/t5/QlikView/Caluclation-Script/m-p/90881#M14770 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a small requirement as below. Can anybody help in this?</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">You can suggest any script calculation or Set analysis (i prefer script calculation)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1402196-187154/pastedImage_2.png" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="" class="jive-image image-1" height="295" src="https://community.qlik.com/legacyfs/online/206488_pastedImage_2.png" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="204" /></A></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i want to <STRONG style="font-style: inherit; font-family: inherit;">reduce column APREIS depending on % Reduction</STRONG> - <EM style="font-weight: inherit; font-family: inherit;">Expected result is as below</EM>...</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1402196-187155/pastedImage_3.png" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="" class="jive-image image-2" height="320" src="https://community.qlik.com/legacyfs/online/206489_pastedImage_3.png" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="345" /></A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Note - Comma is decimal point in Last column</P></BODY></HTML> Thu, 28 Jun 2018 11:06:43 GMT Anonymous 2018-06-28T11:06:43Z Caluclation Script https://community.qlik.com/t5/QlikView/Caluclation-Script/m-p/90881#M14770 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi All,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a small requirement as below. Can anybody help in this?</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">You can suggest any script calculation or Set analysis (i prefer script calculation)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1402196-187154/pastedImage_2.png" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="" class="jive-image image-1" height="295" src="https://community.qlik.com/legacyfs/online/206488_pastedImage_2.png" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="204" /></A></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i want to <STRONG style="font-style: inherit; font-family: inherit;">reduce column APREIS depending on % Reduction</STRONG> - <EM style="font-weight: inherit; font-family: inherit;">Expected result is as below</EM>...</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-1402196-187155/pastedImage_3.png" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;"><IMG alt="" class="jive-image image-2" height="320" src="https://community.qlik.com/legacyfs/online/206489_pastedImage_3.png" style="border-width: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="345" /></A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Note - Comma is decimal point in Last column</P></BODY></HTML> Thu, 28 Jun 2018 11:06:43 GMT https://community.qlik.com/t5/QlikView/Caluclation-Script/m-p/90881#M14770 Anonymous 2018-06-28T11:06:43Z Re: Caluclation Script https://community.qlik.com/t5/QlikView/Caluclation-Script/m-p/90882#M14771 <HTML><HEAD></HEAD><BODY><P>Have worked on something similar before... have you seen this?</P><P><A href="https://community.qlikview.com/thread/285228" title="https://community.qlikview.com/thread/285228">Calculation on Column itself | Qlik Community</A></P></BODY></HTML> Thu, 28 Jun 2018 16:34:32 GMT https://community.qlik.com/t5/QlikView/Caluclation-Script/m-p/90882#M14771 sunny_talwar 2018-06-28T16:34:32Z