topic date from to iteration in QlikView

date from to iteration

Anonymous — Wed, 17 Aug 2011 07:36:03 GMT

Here is something I want to share.

It is a example of a date range iteration.

tmp:

load * inline

[from,to,name

'10/08/2010','10/09/2010','Jack'

'01/01/2010','01/03/2010','John'

'01/20/2010','02/03/2010','Mike'

'02/25/2010','03/11/2010','Nic'

];

range:

LOAD

from,

to,

from+iterno()-1 as date_day,

name ,

iterno() as iter

resident tmp

while iterno() <= num(to)-num(from)+1;

date_day	from	name	to	iter
1/1/2010	01/01/2010	John	01/03/2010	1
1/2/2010	01/01/2010	John	01/03/2010	2
1/3/2010	01/01/2010	John	01/03/2010	3
1/20/2010	01/20/2010	Mike	02/03/2010	1
1/21/2010	01/20/2010	Mike	02/03/2010	2
1/22/2010	01/20/2010	Mike	02/03/2010	3
1/23/2010	01/20/2010	Mike	02/03/2010	4
1/24/2010	01/20/2010	Mike	02/03/2010	5
1/25/2010	01/20/2010	Mike	02/03/2010	6
1/26/2010	01/20/2010	Mike	02/03/2010	7
1/27/2010	01/20/2010	Mike	02/03/2010	8
1/28/2010	01/20/2010	Mike	02/03/2010	9
1/29/2010	01/20/2010	Mike	02/03/2010	10
1/30/2010	01/20/2010	Mike	02/03/2010	11
1/31/2010	01/20/2010	Mike	02/03/2010	12
2/1/2010	01/20/2010	Mike	02/03/2010	13
2/2/2010	01/20/2010	Mike	02/03/2010	14
2/3/2010	01/20/2010	Mike	02/03/2010	15
2/25/2010	02/25/2010	Nic	03/11/2010	1
2/26/2010	02/25/2010	Nic	03/11/2010	2
2/27/2010	02/25/2010	Nic	03/11/2010	3
2/28/2010	02/25/2010	Nic	03/11/2010	4
3/1/2010	02/25/2010	Nic	03/11/2010	5
3/2/2010	02/25/2010	Nic	03/11/2010	6
3/3/2010	02/25/2010	Nic	03/11/2010	7
3/4/2010	02/25/2010	Nic	03/11/2010	8
3/5/2010	02/25/2010	Nic	03/11/2010	9
3/6/2010	02/25/2010	Nic	03/11/2010	10
3/7/2010	02/25/2010	Nic	03/11/2010	11
3/8/2010	02/25/2010	Nic	03/11/2010	12
3/9/2010	02/25/2010	Nic	03/11/2010	13
3/10/2010	02/25/2010	Nic	03/11/2010	14
3/11/2010	02/25/2010	Nic	03/11/2010	15
10/8/2010	10/08/2010	Jack	10/09/2010	1
10/9/2010	10/08/2010	Jack	10/09/2010	2

date from to iteration

gandalfgray — Wed, 17 Aug 2011 08:45:02 GMT

Thanks for sharing Pieter,

could be handy sometime!