topic Re: Expression for Yesterday in QlikView https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459742#M1150823 <HTML><HEAD></HEAD><BODY><P>Try sum({&lt;MyDate={'$(=date(today()-1))'}&gt;} sales). Change <EM>MyDate</EM> to the name of your date field and <EM>sales</EM> to the name of your sales field.</P></BODY></HTML> Tue, 11 Jun 2013 10:56:47 GMT Gysbert_Wassenaar 2013-06-11T10:56:47Z Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459741#M1150822 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How can i write the expression for yesterday. I want to get the sum of sales for yesterday using expression. Please help me..</P><P></P><P>Thanks</P><P></P><P>Renjith Kumaran</P></BODY></HTML> Tue, 11 Jun 2013 10:54:20 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459741#M1150822 2013-06-11T10:54:20Z Re: Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459742#M1150823 <HTML><HEAD></HEAD><BODY><P>Try sum({&lt;MyDate={'$(=date(today()-1))'}&gt;} sales). Change <EM>MyDate</EM> to the name of your date field and <EM>sales</EM> to the name of your sales field.</P></BODY></HTML> Tue, 11 Jun 2013 10:56:47 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459742#M1150823 Gysbert_Wassenaar 2013-06-11T10:56:47Z Re: Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459743#M1150824 <HTML><HEAD></HEAD><BODY><P>No, It gives me off values..</P></BODY></HTML> Tue, 11 Jun 2013 11:04:38 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459743#M1150824 2013-06-11T11:04:38Z Re: Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459744#M1150825 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">You can try it with Double Quotes maybe</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 936px;"><TBODY><TR><TD class="xl65" height="17" width="936">SUM({&lt;Date = {"$(=DATE(TODAY()-1))"}&gt;} Sales)</TD></TR></TBODY></TABLE><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Tue, 11 Jun 2013 11:07:46 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459744#M1150825 rustyfishbones 2013-06-11T11:07:46Z Re: Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459745#M1150826 <HTML><HEAD></HEAD><BODY><P>That too gave me off values..</P><P></P><P>My situation is that i have two dimension named process center and Driver. i want to write a expresssion for the graded quantity and want that without selecting the date.</P><P></P><P>That is its 6/11 today. on loading the chart i want to fill the pivot tabke with yesterday's sum(gradedqty).</P><P></P><P></P><P>Thanks</P><P></P><P>Renjith Kumaran<IMG __jive_id="42461" class="jive-image" alt="new.png" src="https://community.qlik.com/legacyfs/online/42461_new.png" /></P></BODY></HTML> Tue, 11 Jun 2013 11:16:14 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459745#M1150826 2013-06-11T11:16:14Z Re: Expression for Yesterday https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459746#M1150827 <HTML><HEAD></HEAD><BODY><P>Ren ,</P><P></P><P>Try to calculate the yesterday as Date -1 in script.</P></BODY></HTML> Tue, 11 Jun 2013 11:20:28 GMT https://community.qlik.com/t5/QlikView/Expression-for-Yesterday/m-p/459746#M1150827 sujeetsingh 2013-06-11T11:20:28Z