topic Sorting problem with last and before in QlikView https://community.qlik.com/t5/QlikView/Sorting-problem-with-last-and-before/m-p/316148#M1201526 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am calculating the $ Change column with this expression</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=(before( sum(Balance), 1 ) - sum(Balance))</PRE><BR /><BR /> <P>Now the problem is, I want to sort this in ascending order, basically find out which account has the most declined balance.</P><P>I tried the following expressions for sorting but both do not seem to be working.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=(before( sum(Balance), 1 ) - sum(Balance))</PRE><BR /><BR /> <P>or</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=last( (before( sum(Balance), 1 ) - sum(Balance)))</PRE><BR /><BR /> <P>Has anyone had any luck getting this working before?</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3935_sourceID:3935" /></P><P></P><P></P></BODY></HTML> Fri, 25 Mar 2011 03:06:53 GMT 2011-03-25T03:06:53Z Sorting problem with last and before https://community.qlik.com/t5/QlikView/Sorting-problem-with-last-and-before/m-p/316148#M1201526 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am calculating the $ Change column with this expression</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=(before( sum(Balance), 1 ) - sum(Balance))</PRE><BR /><BR /> <P>Now the problem is, I want to sort this in ascending order, basically find out which account has the most declined balance.</P><P>I tried the following expressions for sorting but both do not seem to be working.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=(before( sum(Balance), 1 ) - sum(Balance))</PRE><BR /><BR /> <P>or</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=last( (before( sum(Balance), 1 ) - sum(Balance)))</PRE><BR /><BR /> <P>Has anyone had any luck getting this working before?</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3935_sourceID:3935" /></P><P></P><P></P></BODY></HTML> Fri, 25 Mar 2011 03:06:53 GMT https://community.qlik.com/t5/QlikView/Sorting-problem-with-last-and-before/m-p/316148#M1201526 2011-03-25T03:06:53Z