Limit Pivot Table to Show Just Today Through the Next 2 Weeks

[asmithids]

Hello,

I have a pivot table that I need to limit the view to showing records from today through the next two weeks and have it maintain a two week look forward as the days pass based on the Arrival Date field. The chart is not to be affected by any selected filters in the dashboard.  I am not sure how to script this condition.  The qvw is attached.

Thank you in advance for any assistance. 

[ramoncova06]

this link should help

QlikView App: Dates, Date Ranges and Set Analysis

[ramoncova06 · Accepted solution]

here is the expression

Sum({< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)

and your document

if you want it to ignore all selections just add a 1 to your set analysis opening

Sum({1< WhseARRIVALDATE= {">=$(=(num(today())))<=$(=((floor(weekend(today(),2)))))"}>}SHIPPEDQTY)

[asmithids]

Thank you Ramon!!!

[#5]

Smith, the other Approach create e Flag in your Master calender use Calculated Dimension in Pivot table.