topic Re: Generate data in QlikView in QlikView

Generate data in QlikView

BrunPierre — Sat, 02 Apr 2022 07:41:27 GMT

Hi everyone!

I wish to treat this table below as if there will be not further update to the records, but however generate from resident or perhaps autogenerate with only updates in the date field (incremental) as depicted in the desired table.

Many thanks.

Sample Table

Date	Name	Amount	Return on a daily basis
2/4/2022	LeJordan Minks	1,800	0.79

Desired Table

Date	Name	Amount	Return on a daily basis
2/4/2022	LeJordan Minks	1,800	0.79
3/4/2022	LeJordan Minks	1,800	0.79
4/4/2022	LeJordan Minks	1,800	0.79

Re: Generate data in QlikView

MarcoWedel — Sat, 02 Apr 2022 13:47:48 GMT

can you specify how the resulting table can be derived from your sample table?

Re: Generate data in QlikView

BrunPierre — Sat, 02 Apr 2022 14:43:52 GMT

@MarcoWedel So the intial load was from a QVD as shown below with the assumption that the QVD will not be updated again. Thus, I want to continue adding to the already loaded table importantly with increasing date.

[Sample Table]:
LOAD Date,
Name,
Amount,
[Return on a daily basis]

FROM TransacTable.qvd(qvd);

Hope this clarifies things, and thanks.

Re: Generate data in QlikView

BrunPierre — Tue, 03 May 2022 12:51:08 GMT

[FinalTable]:
LOAD DATE(Date + ITERNO()-1) AS Date,
Name,
Amount,
[Return on a daily basis]

RESIDENT [Sample Table]

WHILE ITERNO() <= TODAY() - Date;

DROP TABLE [Sample Table];