Sum between to values in a period where one date is already defined and the other selected

[#1]

Hi everyone,

I'm pretty new at QlikView and I need to create a sum between two dates, the initial date is already defined and the final date will be selected by user.

For example: Sum({$<Date={">'2010-01-01 00:00:00'<$(SelectedDate) "}>} ValueToSum)

I've been searching for this at this forum, but i can't find it.

Help?

[#2]

What is the problem with your expression? It looks good to me, assuming 'SelectedDate' is a variable which gets selected date value.

[#3]

It doesen't work =(

[Anonymous]

try this

= Sum({$<Date={">Timestamp#('2010-01-01 00:00:00','YYYY/MM/DD hh:mm:ss[.fff] TT')<$(SelectedDate) "}>} ValueToSum)

[sasiparupudi1]

Please try

Sum({$<Date={">'2010-01-01 00:00:00'<'$(SelectedDate)' "}>} ValueToSum)

[avinashelite · Accepted solution]

sum({<Calender_Date={"Date={">Timestamp#('2010-01-01 00:00:00','YYYY/MM/DD hh:mm:ss[.fff] TT')<$(SelectedDate) ""}>}ValueToSum)

NOTE: make sure that your date columns have the same date formats

[Kushal_Chawda]

Try,

sum({<Date ={">=$(=Timestamp#('2010-01-01 00:00:00','YYYY-MM-DD'))<=$(=SelectedDate)"}>}ValueToSum)

[#8]

The field had the same format =(