Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,
[Artikel Online],
[Umsatz in € gesamt] - ApplyMap ('Plattforms_Details',Datum, 0) as [Umsatz in €],
[Verkaufte Artikel],
[Umsatz in € gesamt] ,
DDMM
(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