Try with triggers.
Please Find the attached app
Set trigger for both variables vFromDate and vToDate
=('>=' & (date((vFromDate),'DD-MM-YYYY')) & '<=' & (date((vToDate),'DD-MM-YYYY')))
As it is already linked. just give sum(sal) in text box. set analysis is not required in this case
calender obj.qvw 153.8 K
It works fine, Thanks for ur time.
my requirement is by using set expression is it possible, by when user selecting date range automatically that results should displayed. very great ful to you if resolved this...
=sum( if ( date >= $(vFromDate) and date <= $(vToDate), sal))
by using this expression i got the result what i expected, my question is convert this expression into set expression.