topic Re: I want to create a variable with following formula, where n dates are selected(from filter) and a1,a2..an are the numeric values on those dates.How can i do it in qlik sense? in App Development https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385359#M31706 <HTML><HEAD></HEAD><BODY><P>Lets say a1,a2 ...an&nbsp; are sales values on the dates filter selected.Like we do Sum(sales),I want to do something like this</P><P></P><P>Multiply(1+sales) </P><P></P><P>How can i achieve this ??</P></BODY></HTML> Wed, 18 Oct 2017 05:47:56 GMT Anonymous 2017-10-18T05:47:56Z I want to create a variable with following formula, where n dates are selected(from filter) and a1,a2..an are the numeric values on those dates.How can i do it in qlik sense? https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385357#M31704 <HTML><HEAD></HEAD><BODY><P>(1+a1)(1+a2)....(1+an)</P></BODY></HTML> Tue, 17 Oct 2017 19:59:24 GMT https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385357#M31704 Anonymous 2017-10-17T19:59:24Z Re: I want to create a variable with following formula, where n dates are selected(from filter) and a1,a2..an are the numeric values on those dates.How can i do it in qlik sense? https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385358#M31705 <HTML><HEAD></HEAD><BODY><P>If I understand the question</P><P></P><P>='(1+' &amp; Concat(num#(Date), ')(1+') &amp; ')'</P></BODY></HTML> Tue, 17 Oct 2017 21:42:59 GMT https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385358#M31705 maxgro 2017-10-17T21:42:59Z Re: I want to create a variable with following formula, where n dates are selected(from filter) and a1,a2..an are the numeric values on those dates.How can i do it in qlik sense? https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385359#M31706 <HTML><HEAD></HEAD><BODY><P>Lets say a1,a2 ...an&nbsp; are sales values on the dates filter selected.Like we do Sum(sales),I want to do something like this</P><P></P><P>Multiply(1+sales) </P><P></P><P>How can i achieve this ??</P></BODY></HTML> Wed, 18 Oct 2017 05:47:56 GMT https://community.qlik.com/t5/App-Development/I-want-to-create-a-variable-with-following-formula-where-n-dates/m-p/1385359#M31706 Anonymous 2017-10-18T05:47:56Z