Hi cafcPTG2011
Try this solution:
=sum({$<SalesDate={">=$(=date#('2012/03/06','YYYY/MM/DD')+0)"}>}SalesQty)
Here you made 2 mistakes
1. Date() is just used for switch display format, instead of the value. Date#() is the one you need to use. Actually not only Date(), but also Num().
Here is an example for you to understand:
create a straight table, define 1st expression as =Num(1/3,'#,##0.##'), 2 expression as =column(1) * 10
take a look what happen, column 1 value is 0.33, column 2 value is 3.333333333, instead of 3.3
That means, the value stored in memory is still the 0.3333333, it just change the display value as 0.33
Same thing happen for Date().
2.The 2nd thing is very strange, I feel this is a defect of QV, at least it should be an enhancement request. In most of database, the date is recognized as an integer, even qlikview. In most of user case, qlikview can use date variable as both date and integer.
For examples, after add those expression,both these 2 are work. And then take a look for column header:
use as a date variable:
=sum({$<SalesDate={">=$(=now())"}>}SalesQty)
as integer (date is integer, 1day=1; the float value is for hour/min/second):
=sum({$<SalesDate={">=$(=now()+0)"}>}SalesQty)
So, now() is working, let's try to replace it with date#(), oh, why it doesn't work?
=sum({$<SalesDate={">=$(=date#('2012/03/06','YYYY/MM/DD'))"}>}SalesQty)
Try + 0, it is workable now.
=sum({$<SalesDate={">=$(=date#('2012/03/06','YYYY/MM/DD')+0)"}>}SalesQty)
So, what happen? It just convert this value from date string to in integer.
I also feel confused with this result, I don't think a date variable can be a "date string", it must be int or date. So I think this is a bug of QlikView
BTW, my QV version is 11. I tried this solution on my environment, if not working, pls check if your version is same.
