Discussion Board for collaboration on QlikView Scripting.
In my model i load following fields from excel:
Result table from source:
I need make some changes in script level to fill missing values for every Chain, Contractor, EAN, Article for YearMonth from 201301 to last actual YearMonth (calculated by reload time of model)
Model and source file in attachment.
Go to Solution.
Chain, Contractor, EAN, Article, Sum,
date(date#(YearMonth & '01', 'YYYYMMDD'), 'YYYYMM') as YearMonth
(ooxml, embedded labels, table is Sheet1);
Chain, Contractor, EAN, Article,
date(AddMonths($(vmin), IterNo()-1), 'YYYYMM') as YearMonth
while AddMonths($(vmin), IterNo()-1) <= $(vmax);
left join (FinalSales)
load Chain, Contractor, EAN, Article, YearMonth, Sum
DROP Table Sales;
But i need to set min YearMonth as 201301, max - today YearMonth