Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulated calculation with varied date condition

There is a field call Start_Selling_date for each item every year in a item dimension table. I would like to calculate the accumulated sales amount of each item starting from the Start_Selling_Date of current year till today, how can i achieve it? Is it impossible to use set analysis to do it because every item may have different Start_Selling_Date?

2 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

In the expression tab, there are options for "Accumulation":

Capture.PNG

First check to see if these options fit into your needs.

sunny_talwar

But this won't restart every year, will it? I think RangeSum(Above()) should be the solution. But would be difficult to say much without looking at the underlying data