Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
Thanks, at the end both formulas worked. I had just forgotten to take out >} after customer type.
Thanks again for your quick answer.
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])
Thanks, at the end both formulas worked. I had just forgotten to take out >} after customer type.
Thanks again for your quick answer.