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: 
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)