Filtering Pivot Tables

[#1]

I'm trying to apply a date range filter to a pivot table.  I created a calculation condition which says "dateOfService<=EndDate and dateOfService>=StartDate".  This condition is not having the desired effect. Can you please advise as to what I would need to do to get this type of condition.

StartDate and EndDate are input boxes.

[Nicole-Smith]

You don't want it in the calculation condition, you want it in set analysis in the expression.  For example:

sum({<dateofService={'>=$(StartDate)<=$(EndDate)'}>}Sales)

[#3]

Can you give me a small walkthrough as to how to set that up?  I'm still very new to Qlikview.

[Nicole-Smith]

See the attached for an example.