https://community.qlik.com/t5/QlikView/Field-generation/m-p/1775784#M718057 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132984">@AmCh</a>&nbsp;!</P><P>&nbsp; &nbsp; I think that attached app can help you.</P> Tue, 19 Jan 2021 21:05:49 GMT joaopaulo_delco 2021-01-19T21:05:49Z https://community.qlik.com/t5/QlikView/Field-generation/m-p/1775609#M718056 <P>Hi all,</P><P>starting from these Fields (to import):</P><TABLE border="1"><TBODY><TR><TD>c</TD><TD>d</TD><TD>e</TD></TR><TR><TD>0</TD><TD>1,1</TD><TD>2,1</TD></TR><TR><TD>0</TD><TD>2,3</TD><TD>3,2</TD></TR><TR><TD>0</TD><TD>3,4</TD><TD>4,3</TD></TR><TR><TD>0</TD><TD>4,5</TD><TD>5,4</TD></TR><TR><TD>0</TD><TD>5,6</TD><TD>6,5</TD></TR><TR><TD>1</TD><TD>6,7</TD><TD>7,6</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>I want to generate the following fields, respecting these formula:</P><P>j=m*c (m: entered value from the user with an input box)</P><P>k=n*d (n: entered value from the user with an input box)</P><P>l=e</P><P>vMAX=MAX(j,k,l)</P><P><EM>let's take as an example: m=0,5, n=2</EM></P><TABLE border="1"><TBODY><TR><TD>j</TD><TD>k</TD><TD>l</TD></TR><TR><TD>0</TD><TD>2,2</TD><TD>2,1</TD></TR><TR><TD>0</TD><TD>4,6</TD><TD>3,2</TD></TR><TR><TD>0</TD><TD>6,8</TD><TD>4,3</TD></TR><TR><TD>0</TD><TD>9</TD><TD>5,4</TD></TR><TR><TD>0</TD><TD>11,2</TD><TD>6,5</TD></TR><TR><TD>0,5</TD><TD>13,4</TD><TD>7,6</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;and then to pick the max value from the generated field (j,k,l)</P><TABLE border="1"><TBODY><TR><TD>vMAX</TD></TR><TR><TD>2,2</TD></TR><TR><TD>4,6</TD></TR><TR><TD>6,8</TD></TR><TR><TD>9</TD></TR><TR><TD>11,2</TD></TR><TR><TD>13,4</TD></TR><TR><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How can I write this in the script?<BR /><BR />Thanks in advance.</P> Sat, 16 Nov 2024 17:35:59 GMT https://community.qlik.com/t5/QlikView/Field-generation/m-p/1775609#M718056 AmCh 2024-11-16T17:35:59Z https://community.qlik.com/t5/QlikView/Field-generation/m-p/1775784#M718057 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132984">@AmCh</a>&nbsp;!</P><P>&nbsp; &nbsp; I think that attached app can help you.</P> Tue, 19 Jan 2021 21:05:49 GMT https://community.qlik.com/t5/QlikView/Field-generation/m-p/1775784#M718057 joaopaulo_delco 2021-01-19T21:05:49Z https://community.qlik.com/t5/QlikView/Field-generation/m-p/1777225#M718058 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132984">@AmCh</a>&nbsp;! Can you mark the post as solved?</P> Mon, 25 Jan 2021 17:00:10 GMT https://community.qlik.com/t5/QlikView/Field-generation/m-p/1777225#M718058 joaopaulo_delco 2021-01-25T17:00:10Z