compare dates using Set analysis

[#1]

Hello All,  I am using QV 11 with Pivot table.  My pivot table is having 2 dimensions along with other dimensions also. These 2 dimensions are RequiredDate and DeliveredDate.  On my expressions side, I have to display as on Required Date how much qty is Delivered. so I have written the expression as  sum({< DeliveryDate = {'<=$(=(RequiredDate))'} >} DeliveredQty)   But this expression is not giving me correct qty.  If I select the Order date then it gives the correct qty.  Please guide me on this.

[spividori]

Try the following.

If not, you could upload an example to make it easier to help.

sum({$<RequiredDate={"=DeliveryDate=RequiredDate"}>} DeliveredQty)

Regards.

[Gysbert_Wassenaar]

See attached example for an explanation.

[#4]

Thanks to both...  But I got the solution as sum({< DeliveryDate = {'<=$(RequiredDate)'} >} DeliveredQty)  and it worked fine.