
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can i get Last 4 weeks data in Pivot table from Excel data which contains 9 weeks data
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.
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Rama1 Can you please attach the excel file with the result you are trying to accomplish ?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
