Qlik Community

QlikView Documents

Documents for QlikView related information.

MAT_from_to.qvw

stantrolav
Contributor II

MAT_from_to.qvw

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

and

from 2010 May to 2011 April in second bar named 2011

Attachments
Comments
stantrolav
Contributor II

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?

stantrolav
Contributor II

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?

Not applicable

I had published a document some time ago. How to create easily YTD, moving total. I can help you.

http://community.qlik.com/docs/DOC-4821

Fabrice

stantrolav
Contributor II

I found answer for my task.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

The solution is in this IntervalMatch() function.

IntervalMatch:

IntervalMatch (Date)

Load distinct FromDate, ToDate resident Intervals;


Thanks to Henric Cronström for this good post.

Version history
Revision #:
1 of 1
Last update:
‎11-01-2013 05:40 AM
Updated by: