Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Help with YTD, rangesum() and aggr()

Hello everybody,

currently I have this chartchart.JPG

the bars represent aggregated sales for the year. Currently I am using this as measure


currently I don't have sales value for future periods so the bars stop growing after this month ( X axis is my variable defined as "Time_Period").

I need the aggregation to start from zero again every 12 periods (every time the month of the period is 04)

thanks in advance!

2 Replies

Would you be able to share a sample app to help you with this?

Contributor III
Contributor III

Unfortunately I cannot, but I hope this example image illustrates what I want to achieve. What I want to do is what you see here on the third column, after 12 periods, the aggregated value resets.


Currently I have achieved it by using set condition and an if based on which fiscal period we are in...but I would like to see if the aggr or rangesum allow this kind of reset.