QlikSense: Chart Show latest 26 Weeks

[steve1982]

Hi,

I has a line chart which Fiscal Week is dimension. The current graph show all the fiscal week value. I need the graph to show latest 26 weeks. For example, this week is 201907, the graph will show from 201834 to 201907.

 

Thanks

Steve

[Channa]

sum({<Date={‘>=$(=WeekStart(Max(Date), -25))<=$(=Date(Max(Date)))’}>} Sales )

try this