Pivot Table 1 week view

[Sophie014]

Hi all, 

I'm currently in the process of creating my first Qlik Dashboard and need some help please!

I'm looking to recreate a pivot table I currently have in excel. 

Is there a way of making the column automatically show only dates in the last week (would need to be mon - sun) but with the ability to change the week view I want to look at? I have pivot set up how I want it, except for the fact it's pulling every day that there is data for. E.g. today I would want it to show data from week commencing 7th September but if I wanted to I could change the view to week commencing 3rd August?

Thanks in advance!

[dplr-rn]

You can use set analysis.

taking a simple example. sales in last 7 days

Sum(  {<OrderDate={">=$(=Date(Max(OrderDate)-7))"}>}  LineSalesAmount)

So in case of a pivot you would have this expression as measure and Date as dimension.

As we are using Max of date. If you create a filter on orderdate. and you select a previous date the values in pivot will change on it own