topic Before function with variable in pivot in QlikView https://community.qlik.com/t5/QlikView/Before-function-with-variable-in-pivot/m-p/150125#M28207 <HTML><HEAD></HEAD><BODY><P>I'm trying to use the before function with a variable in a pivot and can't get it to work as wanted. What I wan't to do is to calculate one of the rows from the previous column data.</P><P>In the first two columns it works but then onwards, when the calculated values should change, it still uses the static variable value.</P><P>Here is the calculation used:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />if( ColumnNo( )=1, <B><I>$(variable)</I></B>, (before($variable) + before(sum(Something)))<BR /></PRE><BR /><BR /> <P>Please see attached file for further explanation. Is there another function to use or any work around ?</P><P>/Michael</P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 23 Jul 2009 18:55:00 GMT 2009-07-23T18:55:00Z Before function with variable in pivot https://community.qlik.com/t5/QlikView/Before-function-with-variable-in-pivot/m-p/150125#M28207 <HTML><HEAD></HEAD><BODY><P>I'm trying to use the before function with a variable in a pivot and can't get it to work as wanted. What I wan't to do is to calculate one of the rows from the previous column data.</P><P>In the first two columns it works but then onwards, when the calculated values should change, it still uses the static variable value.</P><P>Here is the calculation used:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />if( ColumnNo( )=1, <B><I>$(variable)</I></B>, (before($variable) + before(sum(Something)))<BR /></PRE><BR /><BR /> <P>Please see attached file for further explanation. Is there another function to use or any work around ?</P><P>/Michael</P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 23 Jul 2009 18:55:00 GMT https://community.qlik.com/t5/QlikView/Before-function-with-variable-in-pivot/m-p/150125#M28207 2009-07-23T18:55:00Z