Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
maxgro
MVP
MVP

If I understand the question

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

Anonymous
Not applicable
Author

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