Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

If I understand the question

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

Contributor
Contributor

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