topic Re: Dynamically extending tables in QlikView

Dynamically extending tables

Mon, 14 Sep 2015 16:13:54 GMT

Dear all,

I read in a number of entries, each with 3 Dates: Date_1, Date_2, Date_3. Each date is the Thursday of a week.

Now I would need to display a dynamicly extending(?) table showing the 3 dates AND
In between these dates extend the displayed table with more rows, one for each "missing week":

E.g. when I read in
Date_1 = 2015-08-06
Date_2 = 2015-08-20
Date_3 = 2015-08-27

I would need to display a table like:
Date_1 = 2015-08-06
Date_1+1 = 2015-08-13
Date_2 = 2015-08-20
Date_3 = 2015-08-27

If 2 weeks or 4 weeks are missing in between 2 dates, I need to add these 4 lines...

Can anyone help?

Thanks & Best regards
Oliver

Re: Dynamically extending tables

m_woolf — Mon, 14 Sep 2015 16:42:50 GMT

Generating Missing Data In QlikView

Re: Dynamically extending tables

MarcoWedel — Mon, 14 Sep 2015 20:49:20 GMT

Hi,

one solution could be:

table1:
LOAD * INLINE [
    Date
    2015-08-06
    2015-08-20
    2015-08-27
    2015-09-17
    2015-10-08
];

LOAD Date(Date+IterNo()*7) as Date
While Date+IterNo()*7 < PreviousDate;
LOAD *, Previous(Date) as PreviousDate
Resident table1
Order By Date desc;

hope this helps

regards

Marco