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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

For accumulation, you can try something like this:

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

Not applicable
Author

Hi Sunny,

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

sunny_talwar

Would you be able to share a sample?