Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Can you give me a small walkthrough as to how to set that up? I'm still very new to Qlikview.
See the attached for an example.