Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
asmithids
Partner - Creator II
Partner - Creator II

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

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. 

1 Solution

Accepted Solutions
ramoncova06
Specialist III
Specialist III

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)

View solution in original post

4 Replies
ramoncova06
Specialist III
Specialist III

ramoncova06
Specialist III
Specialist III

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
Partner - Creator II
Partner - Creator II
Author

Thank you Ramon!!!

Not applicable

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