topic Re: Show data through yesterday in QlikView https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582772#M479155 <HTML><HEAD></HEAD><BODY><P>Add Datefield also.</P><P></P><P>Date = {'&lt;$(=Today())'}</P></BODY></HTML> Thu, 13 Feb 2014 15:39:03 GMT MK_QSL 2014-02-13T15:39:03Z Show data through yesterday https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582771#M479154 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>My formula is as follows:</P><P><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">CurrentPeriodWeek</SPAN><SPAN style="font-size: 8pt;">={1}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">INV|VoidFlag</SPAN><SPAN style="font-size: 8pt;">-={Y}, DB|Source={'TP'}, LOC|CorpFlag={0}, TP|StoreNumber-={1,9}, INV|TransTypeID={1,17}&gt;}TS|GrossRev) </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Suggestions?</SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Thanks</SPAN></P><P></P></BODY></HTML> Thu, 13 Feb 2014 15:35:54 GMT https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582771#M479154 jenmclean 2014-02-13T15:35:54Z Re: Show data through yesterday https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582772#M479155 <HTML><HEAD></HEAD><BODY><P>Add Datefield also.</P><P></P><P>Date = {'&lt;$(=Today())'}</P></BODY></HTML> Thu, 13 Feb 2014 15:39:03 GMT https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582772#M479155 MK_QSL 2014-02-13T15:39:03Z Re: Show data through yesterday https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582773#M479156 <HTML><HEAD></HEAD><BODY><P>Thanks! That did it.</P><P></P><P>Jennie</P></BODY></HTML> Thu, 13 Feb 2014 15:48:39 GMT https://community.qlik.com/t5/QlikView/Show-data-through-yesterday/m-p/582773#M479156 jenmclean 2014-02-13T15:48:39Z