https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589938#M43261 Thanks for your reply!<BR />Could you explain more in detail.<BR />Moreover i want to do the scripting in data modeling and dont want to do it in excel and load the data. Mon, 10 Jun 2019 10:54:36 GMT LP27 2019-06-10T10:54:36Z https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589928#M43259 <P>Hi Qlikers,</P><P>I am new to Qlik environment . I want to know logic for this scenario -&nbsp;</P><P>I have got Column as <STRONG>Decision Points</STRONG> and <STRONG>Year</STRONG> -</P><TABLE border="1"><TBODY><TR><TD><STRONG>Decision Points&nbsp;</STRONG></TD><TD><STRONG>Year</STRONG></TD></TR><TR><TD>PR1</TD><TD>46</TD></TR><TR><TD>PR2</TD><TD>37</TD></TR><TR><TD>PR3</TD><TD>98</TD></TR><TR><TD>PR4</TD><TD>64</TD></TR><TR><TD>PR5</TD><TD>88</TD></TR><TR><TD>PR6</TD><TD>46</TD></TR><TR><TD>PR7</TD><TD>89</TD></TR><TR><TD>PR8</TD><TD>32</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to now multiply pre defined numbers for the values in Decision Point column, like - all the values of <STRONG>Year</STRONG>&nbsp;column should be multiplied as -&nbsp;&nbsp;</P><P>If it is PR1 then 46(value in Year column ) *<STRONG> 16.05%</STRONG>(pre defined value).</P><P>If it is PR2 then 37(value in Year column ) *<STRONG> 7.80%(</STRONG>pre defined value).</P><P>If it is PR3 then 98(value in Year column ) * <STRONG>10.13%</STRONG>(pre defined value).</P><P>If it is PR4 then 64(value in Year column ) * <STRONG>11.14%</STRONG>(pre defined value).</P><P>If it is PR5 then 88(value in Year column ) * <STRONG>10.11%</STRONG>(pre defined value).</P><P>If it is PR6 then 32(value in Year column ) * <STRONG>25.38%</STRONG>(pre defined value).</P><P>If it is PR7 then 89(value in Year column ) * <STRONG>10.88%</STRONG>(pre defined value).</P><P>If it is PR8 then 46(value in Year column ) *<STRONG> 8.32%</STRONG><SPAN>(pre defined value).</SPAN></P><P><FONT face="inherit">Note : Pre-Defined </FONT>values will be same as defined above for PR1 to PR8. Only values&nbsp; in years column will change.</P><P><FONT face="inherit">can some one help me which this logic here please ?</FONT></P><P><FONT face="inherit">Thanks in advance,</FONT></P><P><FONT face="inherit">LP27&nbsp;</FONT></P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 20:41:54 GMT https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589928#M43259 LP27 2024-11-16T20:41:54Z https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589931#M43260 <P>hi&nbsp;</P><P>your best option , is to load a table with mulitplier for each <STRONG>Decision Point value&nbsp;</STRONG></P><P><STRONG>this table could come from excel sheet and will have two fields :</STRONG></P><P><STRONG>Decision Point,multiplier&nbsp;</STRONG></P><P><STRONG>than you can use this expresion:</STRONG></P><P><STRONG>year*mulitplier&nbsp;</STRONG></P> Mon, 10 Jun 2019 10:34:44 GMT https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589931#M43260 lironbaram 2019-06-10T10:34:44Z https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589938#M43261 Thanks for your reply!<BR />Could you explain more in detail.<BR />Moreover i want to do the scripting in data modeling and dont want to do it in excel and load the data. Mon, 10 Jun 2019 10:54:36 GMT https://community.qlik.com/t5/App-Development/Multipy-values-with-pre-defined-values-in-qlik-sense/m-p/1589938#M43261 LP27 2019-06-10T10:54:36Z