Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Values to date 30 days ago/ Set Analysis

Hello,

I changed a lot but still cannot figure out:

count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today())-30)"}>}Delivery)

Count the Deliveryno. older than thirty days from today . 

I always got wrong value. 

Hope someone can help. 

Thanks a lot.

Best. 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

after replacing the date format with your own try  below date part of the expression

Date(today()-30, 'DD-MMM-YYYY')

 

count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today()-30, 'DD-MMM-YYYY'))"}>}Delivery)

 

View solution in original post

1 Reply
dplr-rn
Partner - Master III
Partner - Master III

after replacing the date format with your own try  below date part of the expression

Date(today()-30, 'DD-MMM-YYYY')

 

count({<[deliverydate.autoCalendar.Date]={"<=$(=Date(today()-30, 'DD-MMM-YYYY'))"}>}Delivery)