topic Different timeframes in expression in QlikView https://community.qlik.com/t5/QlikView/Different-timeframes-in-expression/m-p/143634#M22820 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm needing to calculate sum of account receivables of a month / avg of sales of previous 12 months.</P><P>I have to work at detailed level (I cannot pre-process cummulated averages).</P><P>Any clue ?</P><P>Thanks in advance</P><P>Cheers</P></BODY></HTML> Fri, 08 May 2009 05:12:38 GMT 2009-05-08T05:12:38Z Different timeframes in expression https://community.qlik.com/t5/QlikView/Different-timeframes-in-expression/m-p/143634#M22820 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm needing to calculate sum of account receivables of a month / avg of sales of previous 12 months.</P><P>I have to work at detailed level (I cannot pre-process cummulated averages).</P><P>Any clue ?</P><P>Thanks in advance</P><P>Cheers</P></BODY></HTML> Fri, 08 May 2009 05:12:38 GMT https://community.qlik.com/t5/QlikView/Different-timeframes-in-expression/m-p/143634#M22820 2009-05-08T05:12:38Z Different timeframes in expression https://community.qlik.com/t5/QlikView/Different-timeframes-in-expression/m-p/143635#M22821 <HTML><HEAD></HEAD><BODY><P>The "book answer" in ver. 8.5 is "Set Analysis".</P><P>Or, you can have a separate month field and link it to your AR months with a set of flags - SameMonthFlag, Last12MonthFlag, etc. Once you do that, you can use your new Month field as a Dimension in the chart and use your flags as multipliers in your expressions:</P><P>sum(AR_Amount * SameMonthFlag) / (sum(Sales * Last12MonthFlag) / 12)</P><P>cheers,</P><P>Oleg</P></BODY></HTML> Fri, 08 May 2009 10:04:24 GMT https://community.qlik.com/t5/QlikView/Different-timeframes-in-expression/m-p/143635#M22821 Oleg_Troyansky 2009-05-08T10:04:24Z