topic Re: Above function and pivot tables in QlikView https://community.qlik.com/t5/QlikView/Above-function-and-pivot-tables/m-p/663531#M241728 <HTML><HEAD></HEAD><BODY><P>Try with the Before in the expression in place of the Above use Before but check your cell data also.</P></BODY></HTML> Fri, 11 Jul 2014 20:06:49 GMT its_anandrjs 2014-07-11T20:06:49Z Above function and pivot tables https://community.qlik.com/t5/QlikView/Above-function-and-pivot-tables/m-p/663530#M241727 <HTML><HEAD></HEAD><BODY><P>I have chart that looks like this. Year is the dimension, the other columns are expressions.</P><P></P><P>Year&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp; vs. PY</P><P>2014&nbsp;&nbsp;&nbsp;&nbsp; 1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>2015&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp; 100%</P><P>2016&nbsp;&nbsp;&nbsp;&nbsp; 2500&nbsp;&nbsp;&nbsp;&nbsp; 25%</P><P></P><P>I am getting the "vs. PY" value with an expression that looks like:</P><P></P><P>( Sum(Value) - Above(Sum(Value)) ) / Above(Sum(Value))</P><P></P><P>It's all great until I make it a Pivot Table and drag the fields around so that Years are the columns, and the expressions are rows. Then the "vs. PY" row has now values.</P><P></P><P>Any idea how to keep the same logic but have it work pivoted as described?</P></BODY></HTML> Fri, 11 Jul 2014 20:00:10 GMT https://community.qlik.com/t5/QlikView/Above-function-and-pivot-tables/m-p/663530#M241727 mhassinger 2014-07-11T20:00:10Z Re: Above function and pivot tables https://community.qlik.com/t5/QlikView/Above-function-and-pivot-tables/m-p/663531#M241728 <HTML><HEAD></HEAD><BODY><P>Try with the Before in the expression in place of the Above use Before but check your cell data also.</P></BODY></HTML> Fri, 11 Jul 2014 20:06:49 GMT https://community.qlik.com/t5/QlikView/Above-function-and-pivot-tables/m-p/663531#M241728 its_anandrjs 2014-07-11T20:06:49Z