topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169850#M40489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><H3>use ({1&lt;Año={$(=Max(Año)-1)}&gt;} Amount)</H3><P style="font-weight: bold"></P><P style="font-weight: bold">Good luck!</P><P style="font-weight: bold">Rainer</P></BODY></HTML> Fri, 14 Jan 2011 12:27:09 GMT 2011-01-14T12:27:09Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169849#M40488 <HTML><HEAD></HEAD><BODY><P style="font-style: italic"></P><P></P><P></P><P>Sum</P><P></P><P>({1&lt;Año={<B><I>$(=GetFieldSelections(Año))</I></B>}&gt;} Amount)</P><P>Please,</P><BR /><BR /> <P>How I can subtract a year to the user's selection ?</P></BODY></HTML> Fri, 14 Jan 2011 12:24:23 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169849#M40488 2011-01-14T12:24:23Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169850#M40489 <HTML><HEAD></HEAD><BODY><P>Hi,</P><H3>use ({1&lt;Año={$(=Max(Año)-1)}&gt;} Amount)</H3><P style="font-weight: bold"></P><P style="font-weight: bold">Good luck!</P><P style="font-weight: bold">Rainer</P></BODY></HTML> Fri, 14 Jan 2011 12:27:09 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169850#M40489 2011-01-14T12:27:09Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169851#M40490 <HTML><HEAD></HEAD><BODY><P>Thanks a lot.</P><P>It's working</P><P>Have a nice day</P></BODY></HTML> Fri, 14 Jan 2011 12:34:31 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/169851#M40490 2011-01-14T12:34:31Z