Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am trying to create a master calendar to calculate the business days in Qlik Sense. But I really miss something which makes my calculation weird.
Please look at it and guide me to correct my error
The issue which I am getting are:
Attach is the file which I am using
DATE(Floor(Open_Date)) as Open_Date,
DATE(Floor(Close_Date)) as Close_Date,
FROM [lib://Files/Make date - Copy.xlsx]
(ooxml, embedded labels, table is Sheet1);
MIN(Open_Date) as minopendate,
MAX(Open_Date) as maxopendate,
MIN(Close_Date) as minclosedate,
MAX(Close_Date) as maxclosedate
LET varMinOpenDate = NUM(PEEK('minopendate',0,'Temp'));
LET varMaxOpenDate = NUM(PEEK('maxopendate',0,'Temp'));
LET varMinCloseDate = NUM(PEEK('minclosedate',0,'Temp'));
LET varMaxCloseDate = NUM(PEEK('maxclosedate',0,'Temp'));
Drop table Temp;
$(varMinOpenDate)+ IterNo()-1 as NUM1,
$(varMinCloseDate)+ IterNo()-1 as NUM2,
DATE($(varMinOpenDate)+ IterNo()-1) as Temp1,
DATE($(varMinCloseDate)+ IterNo()-1) as Temp2
AutoGenerate 1 while $(varMinOpenDate)+ IterNo()-1 <= $(varMaxOpenDate)
and $(varMinCloseDate)+ IterNo()-1 <= $(varMaxCloseDate);
Temp1 as Open_Date,
NetWorkDays(Temp1, Temp2,'12/11/2015', '12/14/2015', '01/12/2016', '01/14/2016') as bddays
You need to create Canonical Calendar.
Check below link.
I tried but very hard to understand for me. May be because I dont know much about the Qlik Sense
Can you please guide me by changing the above script?
Thanks in advance!!