Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
steve1982
New Contributor II

QlikSense: Chart Show latest 26 Weeks

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.

 Untitled.png

Thanks

Steve

1 Reply
Channa
Valued Contributor III

Re: QlikSense: Chart Show latest 26 Weeks

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

 

try this

Channa