topic Re: Expression help in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188449#M886738 <HTML><HEAD></HEAD><BODY><P>or this:</P><P></P><P><STRONG>Sum(Aggr(Sum(DISTINCT <SPAN style="color: #ff0000;">{&lt;trade_dt = {"$(='&lt;' &amp; vYesterday)"}&gt;}</SPAN> pos_lots), pcr_num))</STRONG></P></BODY></HTML> Tue, 20 Sep 2016 10:09:20 GMT sunny_talwar 2016-09-20T10:09:20Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188447#M886736 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">I have the following expression and I would like to add where trade_dt is less than a variable vyesterday.</SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><SPAN style="color: #0000ff;">Sum</SPAN>(<SPAN style="color: #0000ff;">aggr</SPAN>(<SPAN style="color: #0000ff;">sum</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN> <SPAN style="color: #800000;">pos_lots</SPAN>),<SPAN style="color: #800000;">pcr_num</SPAN>)) </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><SPAN style="color: #0000ff;"><STRONG>Let</STRONG></SPAN> <STRONG><EM style=": ; color: #808080;">vYesterday</EM></STRONG> = <SPAN style="color: #0000ff;">Date</SPAN>(<SPAN style="color: #0000ff;">Today</SPAN>()-1,'DD/MM/YYYY'); </SPAN></P><P></P><P><SPAN style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; font-family: arial,helvetica,sans-serif;">Daniel</SPAN></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188447#M886736 danielnevitt 2020-11-25T16:16:04Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188448#M886737 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><SPAN style="font-size: 13.3333px; color: #0000ff;">Sum</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">aggr</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">sum</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;">(</SPAN><SPAN style="font-size: 13.3333px; color: #0000ff;">DISTINCT</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;"> {&lt;<SPAN style="color: #3d3d3d; font-size: 13.3333px;">trade_dt={'&lt;$(<STRONG style="font-size: 13.3333px; color: #3d3d3d;"><EM style="font-weight: inherit; font-size: 13.3333px; font-family: inherit; color: #808080;">vYesterday</EM></STRONG><SPAN style="color: #3d3d3d; font-size: 13.3333px;"> </SPAN>)'}</SPAN>&gt;}</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">pos_lots</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;">),</SPAN><SPAN style="font-size: 13.3333px; color: #800000;">pcr_num</SPAN><SPAN style="color: #3d3d3d; font-size: 13.3333px;">))</SPAN></P></BODY></HTML> Tue, 20 Sep 2016 09:24:28 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188448#M886737 tresB 2016-09-20T09:24:28Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188449#M886738 <HTML><HEAD></HEAD><BODY><P>or this:</P><P></P><P><STRONG>Sum(Aggr(Sum(DISTINCT <SPAN style="color: #ff0000;">{&lt;trade_dt = {"$(='&lt;' &amp; vYesterday)"}&gt;}</SPAN> pos_lots), pcr_num))</STRONG></P></BODY></HTML> Tue, 20 Sep 2016 10:09:20 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/1188449#M886738 sunny_talwar 2016-09-20T10:09:20Z