Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
sayyam005
New Contributor

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?

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

2 Replies
MVP
MVP

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?

If I understand the question

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

sayyam005
New Contributor

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?

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 ??