topic Previous Month Sales in QlikView https://community.qlik.com/t5/QlikView/Previous-Month-Sales/m-p/779179#M1032227 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a doubt in set analysis for calculating sum of previous month sales. The calculation is based on 5 columns</P><P></P><P>The expression i wrote in calculation is:</P><P></P><P>SET Shared.Calculation.SOHValueMonth='SUM({&lt;[FISCAL YEAR]={$1},[FISCAL MONTH]={$2}&gt;} <A>+<B>-<C>+<D>+<E>)';</E></D></C></B></A></P><P></P><P>and calling this calculation in expression as:</P><P></P><P>=NUM($(Shared.Calculation.SOHValueMonth($(=[FISCAL YEAR]),$(Shared.Calculation.CurrentFiscalMonth)-1)), Shared.Format.MoneyRound)</P><P></P><P>Please let me know if my approach is right.... Thanks in advance.</P></BODY></HTML> Wed, 28 Jan 2015 09:46:35 GMT 2015-01-28T09:46:35Z Previous Month Sales https://community.qlik.com/t5/QlikView/Previous-Month-Sales/m-p/779179#M1032227 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a doubt in set analysis for calculating sum of previous month sales. The calculation is based on 5 columns</P><P></P><P>The expression i wrote in calculation is:</P><P></P><P>SET Shared.Calculation.SOHValueMonth='SUM({&lt;[FISCAL YEAR]={$1},[FISCAL MONTH]={$2}&gt;} <A>+<B>-<C>+<D>+<E>)';</E></D></C></B></A></P><P></P><P>and calling this calculation in expression as:</P><P></P><P>=NUM($(Shared.Calculation.SOHValueMonth($(=[FISCAL YEAR]),$(Shared.Calculation.CurrentFiscalMonth)-1)), Shared.Format.MoneyRound)</P><P></P><P>Please let me know if my approach is right.... Thanks in advance.</P></BODY></HTML> Wed, 28 Jan 2015 09:46:35 GMT https://community.qlik.com/t5/QlikView/Previous-Month-Sales/m-p/779179#M1032227 2015-01-28T09:46:35Z