Capture future dates 2 days from today

[drohm002]

Hi, I have a date field called SCHEDULED_FUTURE_DT, I want to create a calculated dimension for my table chart that pulls in all SCHEDULED_FUTURE_DT values that fall within 2 days from today.  Please help! thank you!

[edwin]

you do not need a calculated dimension.  you add the criteria in your expression and QlikView will pull the dates where the expressions are not 0 or null.

try this:  add SCHED_FUTURE_DT as dimension, and in your expression add the modifier:

{<SCHEDULED_FUTURE_DT={">=$(=today())<=$(date(today()+2))"}>}