Loop in QV

Thu, 10 Apr 2014 06:50:38 GMT

Hi guys,

I have a question about the loop in QV. Original I have the date variable, how to expand 12 times of the date starting from the original month+4? You can find the example below, the final table is what I want.

Anyone could help? Thanks!

Original table:

ID	date	score
1	12/2009	80
2	06/2011	50

Final table

ID	date1	date	score
1	04/2010	12/2009	80
1	05/2010	12/2009	80
1	06/2010	12/2009	80
	......
1	03/2011	12/2009	80
2	10/2011	06/2011	50
2	11/2011	06/2011	50
2	12/2011	06/2011	50
	......
2	09/2012	06/2011	50

Re: Loop in QV

CELAMBARASAN — Thu, 10 Apr 2014 06:54:59 GMT

In script

Load

ID,

date,

score,

Date(AddMonths(Date#(date, 'MM/YYYY'), 3 + IterNo()), 'MM/YYYY') AS date1

Resident OriginalTable

While IterNo() <= 12;

Hope it helps

topic Loop in QV in QlikView

Loop in QV

Re: Loop in QV