Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jenmclean
Contributor III
Contributor III

Show data through yesterday

I have one sheet in my app that I want to show data through yesterday only. I am displaying data for this week but DO NOT want to include today's data.

My formula is as follows:

({1<CurrentPeriodWeek={1}, INV|VoidFlag-={Y}, DB|Source={'TP'}, LOC|CorpFlag={0}, TP|StoreNumber-={1,9}, INV|TransTypeID={1,17}>}TS|GrossRev)

Suggestions?

Thanks

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Add Datefield also.

Date = {'<$(=Today())'}

View solution in original post

2 Replies
MK_QSL
MVP
MVP

Add Datefield also.

Date = {'<$(=Today())'}

jenmclean
Contributor III
Contributor III
Author

Thanks! That did it.

Jennie