How can i get Last 4 weeks data in Pivot table from Excel data which contains 9 weeks data

[Rama1]

HI,

I need help on the below requirement.

I'm trying to do something i can do in excel but on a pivot table in QlikSense.

I am using 2 dimensions Week and Customer and Count as measure.

In my excel sheet i have 9 weeks of data with Week column as Week 40, Week 41......Week 49.

I have Date column as Week start data i.e Sunday 6.10.19,27.10.19.......1.12.19.

and  count column for each Client as 1.i want only last 4 weeks data Client count. 

Attached my pivot table sample.

Thank you.

[Wlad_Masi]

@Rama1  Can you please attach the excel file with the result you are trying to accomplish ?

[srdheekonda]

Hi Rama,

I was able to create the last 4 weeks start date dimension for each client based on the available data. Create a flag on top of this dimension to filter the latest 4 weeks records.

Last 4 Weeks Start Date by Client: 

=AGGR(DATE(WeekStart(MAX(DATE_COLUMN))-21,'YYYY-MM-DD'),CLIENT)

I hope this helps