Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
venuatqlik
Contributor
Contributor

Filter Date Dynamically

I need to filter a date field in a filter pane for the last 4 weeks of data. 

 

=DATE([Survey Start Date], 'YYYYMMDD')>Date(Weekstart(WeekName($(=max([Survey Start Date])),-4)),'YYYYMMDD')

when i add this condition to the filter, its not filtering on the right values. 

 

 

 

 

 

 

 

 

 

 
Labels (3)
1 Reply
Chanty4u
MVP
MVP

Try this 

=Date([Survey Start Date]) >= WeekStart(Max([Survey Start Date]) - 28)

Or may be with calculated dimension

=If([Survey Start Date] >= WeekStart(Max([Survey Start Date]) - 28), [Survey Start Date])