topic Outgoing stocks with Start & End-Date in App Development

Outgoing stocks with Start & End-Date

ahmada — Tue, 25 Feb 2020 14:19:58 GMT

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

Re: Outgoing stocks with Start & End-Date

lorenzoconforti — Tue, 25 Feb 2020 14:37:02 GMT

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/1018506

Re: Outgoing stocks with Start & End-Date

ahmada — Tue, 25 Feb 2020 15:58:14 GMT

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;