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: 
Ns7703
Contributor III
Contributor III

date filter

I want to add filtering in such way that , If I am choosing  march 2024 month then I will get the summed up data till february 2024 

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Something like this

=Sum({<Date={"<=$(=Date(AddMonths(Max(Date), -1), 'YYYY-MM'))"}>} Sales)

View solution in original post

1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Something like this

=Sum({<Date={"<=$(=Date(AddMonths(Max(Date), -1), 'YYYY-MM'))"}>} Sales)