topic Re: How to write in the expression in QlikView https://community.qlik.com/t5/QlikView/How-to-write-in-the-expression/m-p/1171542#M891573 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum({&lt;fiscal_period = {"$(='&gt;' &amp; Max(fiscal_period))"}&gt;} anticipated_amount)</STRONG></P></BODY></HTML> Thu, 11 Aug 2016 10:39:16 GMT sunny_talwar 2016-08-11T10:39:16Z How to write in the expression https://community.qlik.com/t5/QlikView/How-to-write-in-the-expression/m-p/1171541#M891572 <HTML><HEAD></HEAD><BODY><P>How to write the expression to get the required results .</P><P>My requirement is :-</P><P></P><P>When I select Fiscal Year =2016 and Fiscal Period =05 .</P><P></P><P>Then the Detail Table - Anticipated Report must show </P><P>The details of Fiscal Year = 2016 and Fiscal Period &gt; 05.</P><P></P><P></P><P>Sample attached.&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-write-in-the-expression/m-p/1171541#M891572 suvechha_b 2020-11-25T16:16:04Z Re: How to write in the expression https://community.qlik.com/t5/QlikView/How-to-write-in-the-expression/m-p/1171542#M891573 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Sum({&lt;fiscal_period = {"$(='&gt;' &amp; Max(fiscal_period))"}&gt;} anticipated_amount)</STRONG></P></BODY></HTML> Thu, 11 Aug 2016 10:39:16 GMT https://community.qlik.com/t5/QlikView/How-to-write-in-the-expression/m-p/1171542#M891573 sunny_talwar 2016-08-11T10:39:16Z