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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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)