Hi, I've been trying to figure out why the calendar function below isn't working for me in qlik sense. I used that code earlier with a different data set and it worked.
"# of calls",
"Average Length of Call (minutes)",
"# of abandoned calls",
"Average Speed of Answer (seconds)"
FROM [lib://AttachedFiles/Call Data - July 2014 to Dec 2015.xlsx]
(ooxml, embedded labels, table is Sheet1);
DECLARE FIELD DEFINITION TAGGED '$Date'
first_month_of_year = 1
Year($1) As Year Tagged '$year',
Month($1) as Month Tagged '$month',
Date($1) as Date Tagged ('$date', '$day'),
Week($1) as Week Tagged '$week',
Weekday($1) as Weekday Tagged '$weekday',
DERIVE FIELDS FROM FIELDS Date USING Calendar;