Alternatives for RangeSum(Above)

[amars]

Hi all,

I have a monthly HeadCount data for my company's HR Qlik Report. I wish to show the aggregation over the financial year(Apr-09-Feb10). Earlier I have use RangeSum(Above()) Style of formula in the report. But Now they want show it Month, Dept wise & if I put Dept after Month , it shows wrong figure because Above will be using the above values. If I put it Dept , Month it works but I want it Month &then Dept. How to solve this does anyone have any solution? Thanks in advance

With Regards,

Amar

[johnw · Accepted solution]

I think you could create a linkage table. Something along these lines:

AsOfMonth, Month
Feb10, Feb10
Feb10, Jan10
Feb10, Dec09
...
Feb10, Apr09
Jan10, Jan10
Jan10, Dec09
...
Jan10, Apr09
...

If you then use AsOfMonth as your chart dimension, it will automatically give you the financial year to date, because those are the months that AsOfMonth connects to.

[amars]

Thanks a lot John, This has solved my long awaiting problem , which was pending for more than 8-9 months. Thanks again

With Regards

Amar