Outgoing stocks with Start & End-Date

[ahmada]

Hello,

i have a table that lists my stocks by item and location, which looks something like this:

Artikelnr	Location	Stock	Start-Date	End-Date
001	Halle-A	100	01.01.2019	29.01.2019
001	Halle-A	60	30.01.2019	05.02.2020
001	Halle-A	30	06.02.2020	25.02.2020
001	Halle-B	10	03.01.2019	01.02.2020
001	Halle-B	50	02.02.2020	25.02.2020

Start and end date indicate how long the stock was the same. Now I wanted to generate a table from this, which lists the stock for each day. This I wanted to use for a line chart. It should look like this:

Artikelnr	Location	Stock	Date
001	Halle-A	100	01.01.2020
001	Halle-A	100	02.01.2020
001	Halle-A	100	03.01.2020
:	:	:	:
001	Halle-A	100	29.01.2020
001	Halle-A	60	30.01.2020

I'd appreciate any help you could give me.

Regards

ahmada

[lorenzoconforti]

If you want to generate rows within the loading script:

https://community.qlik.com/t5/QlikView-App-Development/Autogenerate-dates-for-each-table-row/m-p/101...

[ahmada · Accepted solution]

Thank You.

i solved it with this:

load
%Art_Lag_Dat,

MengeKumTag as Stock,
date(StartDate+ iterno() - 1) as Date
Resident Lagerbestand
while StartDate + iterno() - 1 <= EndDate;