topic Re: % Change in QlikView https://community.qlik.com/t5/QlikView/Change/m-p/415363#M1165036 <HTML><HEAD></HEAD><BODY><P>Hi Melanie,</P><P></P><P>Try with the following as a new expression (the first row will be null, as long as there are no years to compare with):</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13503140895266918" jivemacro_uid="_13503140895266918"><P>Column(3) / Above(Column(3))</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 15 Oct 2012 15:15:30 GMT Miguel_Angel_Baeyens 2012-10-15T15:15:30Z % Change https://community.qlik.com/t5/QlikView/Change/m-p/415362#M1165035 <HTML><HEAD></HEAD><BODY><P>Afternoon</P><P></P><P>My next problem to tackle...</P><P></P><P>I have straight table like the one below, where the RIDDOR is a calculated field from the data loaded in, FinalHeadCount is loaded in from a simple excel spreadsheet and then the incident rate is a calcualtion of the columns. Riddor/FinalHeadCount*100,000</P><P></P><P>How do I show the % change from 2011 to 2012. Obviously I can do this in excel, but I can't seem to get this to work in QV <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="372"><TBODY><TR><TD class="xl65" height="17" width="57">Year</TD><TD class="xl66" style="border-left: medium none;" width="86">RIDDOR</TD><TD class="xl66" style="border-left: medium none;" width="113">FinalHeadCount</TD><TD class="xl66" style="border-left: medium none;" width="116">Incidence Rate</TD></TR><TR><TD class="xl66" height="17" style="border-top: medium none;">2011</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">39</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">3151</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">1,238</TD></TR><TR><TD class="xl66" height="17" style="border-top: medium none;">2012</TD><TD class="xl67" style="border-left: medium none; border-top: medium none;">34</TD><TD class="xl66" style="border-left: medium none; border-top: medium none;">3141</TD><TD class="xl68" style="border-left: medium none; border-top: medium none;">1,082</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 15 Oct 2012 15:10:56 GMT https://community.qlik.com/t5/QlikView/Change/m-p/415362#M1165035 2012-10-15T15:10:56Z Re: % Change https://community.qlik.com/t5/QlikView/Change/m-p/415363#M1165036 <HTML><HEAD></HEAD><BODY><P>Hi Melanie,</P><P></P><P>Try with the following as a new expression (the first row will be null, as long as there are no years to compare with):</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13503140895266918" jivemacro_uid="_13503140895266918"><P>Column(3) / Above(Column(3))</P></PRE><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 15 Oct 2012 15:15:30 GMT https://community.qlik.com/t5/QlikView/Change/m-p/415363#M1165036 Miguel_Angel_Baeyens 2012-10-15T15:15:30Z Re: % Change https://community.qlik.com/t5/QlikView/Change/m-p/415364#M1165037 <HTML><HEAD></HEAD><BODY><P>OMG that is genius!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Mon, 15 Oct 2012 15:19:02 GMT https://community.qlik.com/t5/QlikView/Change/m-p/415364#M1165037 2012-10-15T15:19:02Z