Qlik Community

App Development

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sayyam005
Contributor
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
maxgro
MVP
MVP

If I understand the question

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

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