Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
andrewburke
Contributor
Contributor

Basic formula

I have the following formula which brings me back what I need, but I would want to only show info for when the date is today minus 1 day.

Would anyone know what i should add in to make this work?

sum({<[Group Work Type]={'Hub Revenue'}>} dwrQuantity)

 

Labels (2)
1 Reply
GaryGiles
Specialist
Specialist

Something like this, depending on structure of the DateField

sum({<[Group Work Type]={'Hub Revenue'},[DateField]={''$(=Date(Today()-1))''}>} dwrQuantity)