Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

RANGESUM(ABOVE(Sum([sales]),0,RowNo()))

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
Highlighted

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

Highlighted
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.

Capture.JPG

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.