Fill table with for next? (like recordset.movenext)

Tue, 18 Nov 2014 08:20:56 GMT

Hi there,

first, see my coding in Load Skript:

Deals_List:

LOAD

Start_Datum as Datum,

Status,

Art,

Verkauft,

Verfügbar,

Preis,

Besucher,

Umsatz,

Hersteller,

Artikelnummer,

Titel

FROM

(ooxml, embedded labels, table is Tabelle1);

Plattforms_Details:

mapping load

Datum,

Umsatz

resident Deals_List;

LOAD Plattform,

PlattformVJ ,

Datum,

[Artikel Online],

[Umsatz in € gesamt] - ApplyMap ('Plattforms_Details',Datum, 0) as [Umsatz in €],

[Verkaufte Artikel],

[Umsatz in € gesamt] ,

DDMM

FROM

(ooxml, embedded labels, table is Qlik_2.de);

Now i want to create following scenario:

If Column "Art" = 'Value' than divide Column "Umsatz" by 7 and share out the result to the next 7 following days!

Any idea how to solve this? Is there a possibility to navigate between the data records while loading the table like:

For i = Datum to Datum + 7

[Umsatz in € gesamt] = [Umsatz in € gesamt] + ([Umsatz] / 7)

next i

Thanks and best regards,

Sabrina

topic Fill table with for next? (like recordset.movenext) in QlikView