topic To sum Previous data values using built in functions in QlikView https://community.qlik.com/t5/QlikView/To-sum-Previous-data-values-using-built-in-functions/m-p/229137#M81094 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>I am getting the previous month value using variable PeriodN....with below formula</P><P>=FIELDVALUE('PeriodName', FIELDINDEX('PeriodName', ONLY(PeriodName))-1)</P><P>And in expression</P><P>Sum ({$&lt;PeriodName={'$(#PeriodN)'}&gt;}Values)</P><P><STRONG>Is any other possibility to bring the values using the functions fieldvalue,fieldindex in an expression statement itself to find the same sum of values.</STRONG></P><P><STRONG>without using variable and assigning it,,,</STRONG></P></BODY></HTML> Wed, 06 Oct 2010 10:28:47 GMT 2010-10-06T10:28:47Z To sum Previous data values using built in functions https://community.qlik.com/t5/QlikView/To-sum-Previous-data-values-using-built-in-functions/m-p/229137#M81094 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>I am getting the previous month value using variable PeriodN....with below formula</P><P>=FIELDVALUE('PeriodName', FIELDINDEX('PeriodName', ONLY(PeriodName))-1)</P><P>And in expression</P><P>Sum ({$&lt;PeriodName={'$(#PeriodN)'}&gt;}Values)</P><P><STRONG>Is any other possibility to bring the values using the functions fieldvalue,fieldindex in an expression statement itself to find the same sum of values.</STRONG></P><P><STRONG>without using variable and assigning it,,,</STRONG></P></BODY></HTML> Wed, 06 Oct 2010 10:28:47 GMT https://community.qlik.com/t5/QlikView/To-sum-Previous-data-values-using-built-in-functions/m-p/229137#M81094 2010-10-06T10:28:47Z