topic Working with dates and selections in QlikView

Working with dates and selections

Wed, 15 Jul 2015 09:24:15 GMT

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 — Wed, 15 Jul 2015 09:34:05 GMT

use getfieldselections(myField) to read the selected data

MayilVahanan — Wed, 15 Jul 2015 09:43:41 GMT

Try like this

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

Gysbert_Wassenaar — Wed, 15 Jul 2015 09:43:46 GMT

Instead of MonthStart you would use YearStart.

sunny_talwar — Wed, 15 Jul 2015 09:45:46 GMT

May be this:

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

HTH

Best,

Sunny