Im trying to make master calendar for the purpose of further analysis but faced an error.
Im afraid the reason of that is date format, I lodaded excel file where data is in format YYYY-MM-DD hh:mm, Qlik read it in format DD.MM.YYYY hh:mm:ss. I changed the format manually in DD/MM/YYYY in type of field and started to work on master calendar script, which is as follows (used from Qlik channel on yt):
MinMaxTable: Load min(SaleDate) as MinDate, max(SaleDate) as MaxDate Resident [sales 2018];
Let vMinDate = Num(Peek('MinDate', 0, 'MinMaxTable')); Let vMaxDate = Num(Peek('MaxDate', 0, 'MinMaxTable')); drop table MinMaxTable;
TempCalendar: Load $(vMinDate) + IterNo() -1 as numb, Date([$(vMinDate)] + IterNo() -1) as TempDate AutoGenerate 1 While $(vMinDate) + IterNo() -1 <= $(vMaxDate);