Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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())'}

View solution in original post

jenmclean
Contributor III
Contributor III
Author

Thanks! That did it.

Jennie