topic Create Variance by Year with set analysis in QlikView https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182235#M47965 <HTML><HEAD></HEAD><BODY><P>I have a set of values for 5 years.</P><P>Such as:</P><P>2000 - 10,000</P><P>2001 - 12,000</P><P>2002 - 13,450</P><P>2003 - 9,000</P><P>2004 - 8,000</P><P>I want to show the difference in the values by year. I can do the following with set analysis:</P><P>2003 2004 Difference</P><P>9,000 8,000 1,000</P><P></P><P>What I want is to show the difference by year in a table:</P><P></P><P>2001 2002 2003 2004</P><P>2,000 1,450 -4,450 -1,000</P><P></P><P>Anyway to do this</P></BODY></HTML> Mon, 24 Jan 2011 16:57:14 GMT 2011-01-24T16:57:14Z Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182235#M47965 <HTML><HEAD></HEAD><BODY><P>I have a set of values for 5 years.</P><P>Such as:</P><P>2000 - 10,000</P><P>2001 - 12,000</P><P>2002 - 13,450</P><P>2003 - 9,000</P><P>2004 - 8,000</P><P>I want to show the difference in the values by year. I can do the following with set analysis:</P><P>2003 2004 Difference</P><P>9,000 8,000 1,000</P><P></P><P>What I want is to show the difference by year in a table:</P><P></P><P>2001 2002 2003 2004</P><P>2,000 1,450 -4,450 -1,000</P><P></P><P>Anyway to do this</P></BODY></HTML> Mon, 24 Jan 2011 16:57:14 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182235#M47965 2011-01-24T16:57:14Z Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182236#M47966 <HTML><HEAD></HEAD><BODY><P>I think you need to use the function Above, see in help.</P></BODY></HTML> Mon, 24 Jan 2011 17:44:58 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182236#M47966 2011-01-24T17:44:58Z Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182237#M47967 <HTML><HEAD></HEAD><BODY><P>I'd use an AsOf table. See attached.</P></BODY></HTML> Tue, 25 Jan 2011 02:15:10 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182237#M47967 johnw 2011-01-25T02:15:10Z Re:Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182238#M47968 <HTML><HEAD></HEAD><BODY><P>Works. I appreciate it. Johnny</P></BODY></HTML> Wed, 26 Jan 2011 17:50:03 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182238#M47968 2011-01-26T17:50:03Z Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182239#M47969 <HTML><HEAD></HEAD><BODY><P>Slick. Answered my next questions. Thanks... Johnny</P></BODY></HTML> Wed, 26 Jan 2011 17:50:48 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182239#M47969 2011-01-26T17:50:48Z Create Variance by Year with set analysis https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182240#M47970 <HTML><HEAD></HEAD><BODY><P> Thank you John your answer were useful for me too...thank you</P></BODY></HTML> Mon, 28 May 2012 23:52:40 GMT https://community.qlik.com/t5/QlikView/Create-Variance-by-Year-with-set-analysis/m-p/182240#M47970 2012-05-28T23:52:40Z