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?

[Anonymous]

(1+a1)(1+a2)....(1+an)

[maxgro]

If I understand the question

='(1+' & Concat(num#(Date), ')(1+') & ')'

[Anonymous]

Lets say a1,a2 ...an  are sales values on the dates filter selected.Like we do Sum(sales),I want to do something like this

Multiply(1+sales)

How can i achieve this ??