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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore8
Creator
Creator

set analysis for the filter

Vittore8_0-1599382724429.png

Hi, how can I find the maximum date from a column and subtract 3 days from it, the result should be

Vittore8_1-1599382894286.png

using set analysis

 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Vittore8  in filter you can us below calculated field

=aggr(only({<Date = {">=$(=Date(max(Date)-3))"}>}Date),Date)

View solution in original post

1 Reply
Kushal_Chawda

@Vittore8  in filter you can us below calculated field

=aggr(only({<Date = {">=$(=Date(max(Date)-3))"}>}Date),Date)