topic Re: How to use the dimension information on set analysis? in QlikView https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642280#M476704 <HTML><HEAD></HEAD><BODY><P>try Below(sum(Revenue),1)</P></BODY></HTML> Wed, 21 May 2014 18:25:05 GMT arthur_dom 2014-05-21T18:25:05Z How to use the dimension information on set analysis? https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642279#M476703 <HTML><HEAD></HEAD><BODY><P>I need to make a table with year as dimension, and a column giving the variation from the current year on the row with the past year. I tried to use something like this: =sum({&lt;Year={$(=Year-1)}&gt;} Revenue)&nbsp;&nbsp; to get the revenue of the last year in the current year row, but I've received only 0's in all rows.</P><P></P><P>Follow a simple example with what I'm trying to do. The basis are two columns. One with years (2010 to 2014) and revenues. There are 10 rows for each year.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 21 May 2014 18:14:11 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642279#M476703 2014-05-21T18:14:11Z Re: How to use the dimension information on set analysis? https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642280#M476704 <HTML><HEAD></HEAD><BODY><P>try Below(sum(Revenue),1)</P></BODY></HTML> Wed, 21 May 2014 18:25:05 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642280#M476704 arthur_dom 2014-05-21T18:25:05Z Re: How to use the dimension information on set analysis? https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642281#M476705 <HTML><HEAD></HEAD><BODY><P>It worked! Thanks!</P></BODY></HTML> Wed, 21 May 2014 19:02:33 GMT https://community.qlik.com/t5/QlikView/How-to-use-the-dimension-information-on-set-analysis/m-p/642281#M476705 2014-05-21T19:02:33Z