Working with dates and selections

[#1]

Hi!
I have to sum revenues from the 1st of January, 2015 to a day that an user can select.

For example, if I select the 1st of July, 2015 Qlik returns the sum of revenues from the 1st of January to the 1st of July.

How can I do this?

Thanks!

[alexandros17]

use getfieldselections(myField) to read the selected data

[MayilVahanan]

Hi

Try like this

= Sum({<Date={">=$(=date(YearStart(Max(Date))))<=$(=date(max(Date)))"}, Month=, Year=>} Revenue)

[Gysbert_Wassenaar]

See this discussion: How to select dates for the current month‌

Instead of MonthStart you would use YearStart.

[sunny_talwar]

May be this:

Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'yourDateFormat') & '<=' & Date(Max(Date), 'yourDateFormat'))"}>}Revenue)

HTH

Best,

Sunny