There is an analytics sheet created with qlikview for our company, and the sheet is full of charts and numbers. there are a bunch of line charts that show stats by date and it shows maximum number of dates it can. but i want it to show only last 8 dates. there is also a slicer which user can set which dates he/she wants to see the data, so any user can use that if it wants to see more data. but by default, most of the info is for last 8 dates and the chart shows like last 25 dates which is too much. i couldn't find the solution to this.
you can use date filter in each expression for 8 weeks as below, so by default it shows 8 weeks data. =Date(WeekStart(max([Delivery Date])-63),'YYYY-MM-DD')
