If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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?
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