Documents for QlikView related information.
Data with years, months. The task is to make countig for Artificially created year by selected month.
When I select 2012, April system must to calculate sum of value from 2011 May to 2012 April.
If I select 2011 and 2012, April system must to calculate sum of value
from 2011 May to 2012 April in first bar named 2012
from 2010 May to 2011 April in second bar named 2011
Could anyone help to solve it?
51 views from this doc and 28 views from discussion makes me think that this nut is really difficult for this community. Who could prove professional skills?
It's a problem. I can post material only to resource section. I already made discussion wits this doc here: Sum from.. to.. in accordance with the data from another field
But my publication is in end of discussion list. How can i update it to the top?
I had published a document some time ago. How to create easily YTD, moving total. I can help you.
I found answer for my task.
The solution is in this IntervalMatch() function.
Load distinct FromDate, ToDate resident Intervals;
Thanks to Henric Cronström for this good post.