How to show only last 6 weeks data in Qliksense Pivot table and bar chart

[Rama1]

HI,

I am developing an app using my data sheet in Qliksense.

In my data sheet i have data from week 49 of 2019 to week 6 of 2020 and i uploaded the complete data sheet in my app. and now i want to show only last 6 weeks data in Pivot table.i.e from Week 1 of 2020 to Week 6 of 2020.

My dimensions are Client, Name as rows and Week as Column and Sum(Count) as Measure.

i have Week as Week 1, Week 2 ...Week field

Date i.e Weekstart day(Sunday) as my date for ex: Date for Week 1 is 05.01.20 and Week 2 is 12.01.20 and ....Week 6 is 09.02.20 etc.

I have Week and Date as Date fields in my data.

Can anyone please help me how can i show only last 6 weeks data in Pivot table, Bar chart by using above date fields.

Thanks in advance

[TimvB]

Sum({<Date={$(=Date(Week(Max(Date)-6)))}>}Count)

[benoitgochel]

Create a measure that looks like: 

Sum({<WeekNumField={">$(=$(Week(Max(Date)))-6)"}>}[YourField])