Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))"}>}