Discussion board where members can get started with Qlik Sense.
Hello! I have table with payments. Like:
I want to generate additional table during load, where for each Deal I have record for each month that included in Pack. Like:
To make this connection:
How I can do it?
Go to Solution.
LOAD [Deal ID],
[Price of Pack] / [Month in Pack] AS [Accural Sum],
Date( AddMonths([Purchase Date], iterno()-1) ) AS [Accural Date]
WHILE iterno() <= [Month in Pack];
You have to use For Loop or Iterno() functions for this on the load script data model.
See some examples on the community on this topics.
AddMonths(PurchaseDate, IterNo() - 1) as PurchaseDate
While IterNo() <= Month;
Price/Month as PricePerMonth
Price, PurchaseDate, Month, DealID
6000, 18.02.2016, 6, 1
5000, 01.02.2016, 4, 2
Try this ways
LOAD PriceOfPack / MonthinPack as PriceOfPack, AddMonths( PurDate, IterNo()-1) as PurDate ,MonthinPack,DealId,IterNo() as ID
While IterNo() <= MonthinPack;
LOAD PriceOfPack,Date#(PurDate,'DD.MM.YYYY') AS PurDate,MonthinPack,DealId;
LOAD * Inline
exactly what I need Thanks