Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

asmithbi
Contributor 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. 

Tags (1)
1 Solution

Accepted Solutions
ramoncova06
Valued Contributor III

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

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)

4 Replies
ramoncova06
Valued Contributor III

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

ramoncova06
Valued Contributor III

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

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)

asmithbi
Contributor II

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

Thank you Ramon!!!

Not applicable

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

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

Community Browser