Function for capture date 1 week before.

[#1]

Hi,

I have dashboard weekly reporting, and the simple table is below:

Date	Service Quality
01/01/17	12
02/01/17	13
03/01/17	33
04/01/17	43
05/01/17	72
06/01/17	11
07/01/17	47
08/01/17	67
09/01/17	21
10/01/17	52

Today : 11/01/17 (for example)

- I want to create a bar chart, but only for 1 week before (04/01/17 - 10/01/17).

I already tried function on this link: https://help.qlik.com/en-US/sense/1.1/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/DateAndT..., but no function meet with my question.

Thank You.

[vinieme12]

create flags in load sript using week() function

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/w...

Then in set analysis restrict the week number you want to show data for for example MaX(WeekNum)-1  !!