topic Re: Explain the expression in QlikView https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922141#M989164 <HTML><HEAD></HEAD><BODY><P>...the summation of Qty is done for the periods from MaxPriorPeriod1 to MaxPriorPeriod3 regardless of your selection of Fiscal Month.</P><P></P><P>Regards </P><P></P><P>Burkhard</P></BODY></HTML> Thu, 30 Jul 2015 13:30:15 GMT veidlburkhard 2015-07-30T13:30:15Z Explain the expression https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922140#M989163 <HTML><HEAD></HEAD><BODY><P>Please need help to understand the expression :</P><P></P><P>sum({&lt; [Fiscal Month]=, [Sale Month]={"&lt;=$(MaxPriorPeriod1)&gt;=$(MaxPriorPeriod3)"} &gt;} Qty)</P></BODY></HTML> Thu, 30 Jul 2015 13:22:57 GMT https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922140#M989163 suvechha_b 2015-07-30T13:22:57Z Re: Explain the expression https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922141#M989164 <HTML><HEAD></HEAD><BODY><P>...the summation of Qty is done for the periods from MaxPriorPeriod1 to MaxPriorPeriod3 regardless of your selection of Fiscal Month.</P><P></P><P>Regards </P><P></P><P>Burkhard</P></BODY></HTML> Thu, 30 Jul 2015 13:30:15 GMT https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922141#M989164 veidlburkhard 2015-07-30T13:30:15Z Re: Explain the expression https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922142#M989165 <HTML><HEAD></HEAD><BODY><P>Sum Quantity between&nbsp; SalesMonth&nbsp; greater than MaxPeriod1 but less that MaxPeriod3.</P><P>The Fiscal Month part is there to ignore your selection of this field</P><P>MaxPerdiod1 and MaxPeriod3 are variables</P></BODY></HTML> Thu, 30 Jul 2015 13:34:02 GMT https://community.qlik.com/t5/QlikView/Explain-the-expression/m-p/922142#M989165 robert_mika 2015-07-30T13:34:02Z