I have like this and have the same issue
Calendar: DECLARE FIELD DEFINITION TAGGED '$date'
Parameters first_month_of_year = 1,
fiscal_first_month_of_year = 4
Year($1) As Year Tagged '$year',
if(Year($1) >= 2010, Year($1)) as DropDownYear,
if( Month($1)>=4, Year($1), Year($1) -1) as FiscalYear Tagged '$fiscalyear',
Month($1) as Month Tagged '$month',
if( Month($1)>=4, Month($1)-3,Month($1)+9) as FiscalMonthNumber Tagged '$FiscalMonthNumber',
Date($1) as Date Tagged ('$date', '$day'),
Week($1) as Week Tagged '$week',
Weekday($1) as Weekday Tagged '$weekday',
'Q' & Ceil(Month($1)/3) as FinancialQuarter Tagged '$FinancialQuarter';
DERIVE FIELDS FROM FIELDS [Order_Date] USING Calendar;
and still no joy
yes in your load script when adding your order data create a new field called OrderDate which excludes time (This can be done in your SQL View or Qlik using their respective formatting functions) and build and join your calendar on that new date only field and you will be fine.
Rename your original field orderdatetime so you can use it in your dashboard if you need that granulatity in future charts.
Joanna this almost certainly do your dates actually having a time component that is hidden by Qlik by default. You see duplications of the days because there is hidden timestamp that is different between the same date.
On your primary load of the date field use the following qlik expression to remove the timestamp part
Date(Floor([DateField])) as Date
If qlik understands your date field as a date or date/time it will assign it a number where the whole number represents a calendar day and the decimal numbers represent hours, minutes etc... (time). the Floor function rounds down and effectively turns the date into just a day based date.
hope it helps