Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
What is the problem with your expression? It looks good to me, assuming 'SelectedDate' is a variable which gets selected date value.
It doesen't work =(
try this
= Sum({$<Date={">Timestamp#('2010-01-01 00:00:00','YYYY/MM/DD hh:mm:ss[.fff] TT')<$(SelectedDate) "}>} ValueToSum)
Please try
Sum({$<Date={">'2010-01-01 00:00:00'<'$(SelectedDate)' "}>} ValueToSum)
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
Try,
sum({<Date ={">=$(=Timestamp#('2010-01-01 00:00:00','YYYY-MM-DD'))<=$(=SelectedDate)"}>}ValueToSum)
The field had the same format =(