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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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