Get year from date and use it in formulas - beginner

[vStefano]

Good morning,

I am new to Qliksense and have been experiencing the first issues with formula.

Briefly, I am writing a formula to sum order amount in the current year. In my database there is not a field with the year, just the date.

I have tried the following formula but now value is shown:

=Sum({$<
[DateType]={'Request_Date'},
OnHold = {'No'},
Samples = {'No'},
[DRP Y/N] = {'No'},
[Date Cancelled] = {"1899-12-30"},
[Customer Type] = {'DOM','FOR'}>},
[Date Entered] = {"$(='>=' & Date(YearStart(Today()), 'YYYY-DD-MM') & '<=' & Date(Today(), 'YYYY-DD-MM'))"}>}
[Euro Total])

Can some help me?

Thanks in advance,

Stefano

[martinpohl · Accepted solution]

change it to

=Sum({$<
[DateType]={'Request_Date'},
OnHold = {'No'},
Samples = {'No'},
[DRP Y/N] = {'No'},
[Date Cancelled] = {"1899-12-30"},
[Customer Type] = {'DOM','FOR'}>},
[Date Entered] = {">=$(=Date(YearStart(Today()), 'YYYY-DD-MM'))<=$(=Date(Today(), 'YYYY-DD-MM'))"}>}
[Euro Total])

[vStefano · Accepted solution]

Thanks, at the end both formulas worked. I had just forgotten to take out >} after customer type.

Thanks again for your quick answer.