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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

0 Replies