Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Iterate over date table to autogenerate missing dates with values associated

I have a table that I have loaded from an excel file. This table contains quarters for each year:

Date                     A             B

01/01/2009         34          100

01/04/2009         12            80

01/07/2009         58            20

01/10/2009         24            10

01/01/2010         56            23

01/04/2010         14            40

01/07/2010           9            79

01/10/2010         20           120

and I want to obtain below table:

Date                     A             B

01/01/2009         34          100

02/01/2009         34          100

03/01/2009         34          100

04/01/2009         34          100

....

01/02/2009         34          100

02/02/2009         34          100

03/02/2009         34          100

...

01/04/2009         12            80

02/04/2009         12            80

03/04/2009         12            80

...

01/06/2009         12            80

02/06/2009         12            80

...

01/07/2009         58            20

02/07/2009         58            20

..

01/09/2009         58            20

02/09/2009         58            20

...

01/10/2009         24            10

02/10/2009         24            10

03/10/2009         24            10

04/10/2009         24            10

...

01/11/2009         24            10

...

01/12/2009         24            10

..

01/01/2010         64            30

02/01/2010         64            30


Note that each time a quarter for a year starts I need to autogenerate next dates and repeat values for columns A and B until to reach next quarter. Once next quarter is reached I should begin to repeat new values for columns A and B until next one, and so on.


How to do it in QlikView?

11 Replies
sunny_talwar

So it is all working now?

Not applicable
Author

Yes, all work now. Many thanks