Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Fiscalyear rolling 12 months cumulative values

Hi,

I'm new to qliksense, below is the requirement, can any one please tell me how to do.

Fiscal year starts from July to June.

Measure used = Amount

Thanks in advance.

3 Replies
MVP
MVP

Re: Fiscalyear rolling 12 months cumulative values

For accumulation, you can try something like this:

RangeSum(Before(YourExpression, 0, ColumnNo()))

Not applicable

Re: Fiscalyear rolling 12 months cumulative values

Hi Sunny,

Thanks for quick help, but it's not working.

MVP
MVP

Re: Fiscalyear rolling 12 months cumulative values

Would you be able to share a sample?