Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BrunPierre
Partner - Master II
Partner - Master II

Generate data in QlikView

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
Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II
Author

[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];

View solution in original post

3 Replies
MarcoWedel

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

BrunPierre
Partner - Master II
Partner - Master II
Author

@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.

BrunPierre
Partner - Master II
Partner - Master II
Author

[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];