Linear assets

[#1]

Dear all,

I have the following type of data:

ID	FROM	TO	FACT
	1	5	A
	3	4	B
	4	8	C
	6	7	D
	8	10	E

Is there an easy way to break these intervals down to the smallest possible intervals. What I want to achieve is to be able to select any interval in my dashboard: from 2 to 6 and recieve as possibilities for the fact: A + B + C.

Thanks in advance

[swuehl]

If I understand correctly, you should be able to apply the method Henric described in his latest blog, using a while loop:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates