Setup a variable called vFilterDate. Add a calendar object that uses the variable. Then try something like this as your expression (assuming ShipDate is the field you want to display):
=if(ShipDate-$(vFilterDate)>0, ShipDate-$(vFilterDate), null())
The key thing is you want nulls to result in the expression for dates that dont meet the condition. Then the chart ignores them by default, leaving only th edata you want to display.
Still i ddin't understand Prashant..
In my table I have data for
12th Feb is 6
12th Oct is 8
12th Nov is 4
12th Dec is 2
So If you are selecting 10th December , It will show 18 (6+8+4).
If you select 12th December, it will show 20 (6+8+4+2).
Note: I am using DD/MM/YYYY format...
O yes the problem ws with the format, so mistaken....
working the same approach in the main application,
can u send me the application frm the calender qvd is generated.
thanks a lot...