topic Calculating Row wise differences in QlikView https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/442919#M165100 <HTML><HEAD></HEAD><BODY><P>Can any of you please let me know how can I achieve the row wise differences. Please check the example be;low</P><P></P><P>Already tried posting the message couple of hours back, but couldn't understand why it is not displayed.- Thanks </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1701"><TBODY><TR><TD class="xl31" height="17" width="88">Name</TD><TD class="xl24" width="53">Month</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jan</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Feb</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Mar</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Apr</TD><TD align="right" class="xl25" style="border-left: none;" width="120">May</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jun</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jul</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Aug</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Sep</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Oct</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Nov</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Dec</TD><TD class="xl26" style="border-left: none;" width="120">Total</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Row I</TD><TD class="xl28"> </TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29951.72</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">8800</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">40674.92</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">74612.46</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">-16337.54</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">25276.65</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">9388.71</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">14383</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">22162</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">16099</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">41760</TD><TD align="right" class="xl30" style="border-left: none;">266870.92</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Row II</TD><TD class="xl28" style="border-top: none;"> </TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl30" style="border-top: none; border-left: none;">363778.02</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Difference</TD><TD class="xl28" style="border-top: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl30" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P></P><P>- Sasi </P></BODY></HTML> Wed, 10 Apr 2013 21:56:11 GMT ksasidhars 2013-04-10T21:56:11Z Calculating Row wise differences https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/442919#M165100 <HTML><HEAD></HEAD><BODY><P>Can any of you please let me know how can I achieve the row wise differences. Please check the example be;low</P><P></P><P>Already tried posting the message couple of hours back, but couldn't understand why it is not displayed.- Thanks </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1701"><TBODY><TR><TD class="xl31" height="17" width="88">Name</TD><TD class="xl24" width="53">Month</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jan</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Feb</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Mar</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Apr</TD><TD align="right" class="xl25" style="border-left: none;" width="120">May</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jun</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Jul</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Aug</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Sep</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Oct</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Nov</TD><TD align="right" class="xl25" style="border-left: none;" width="120">Dec</TD><TD class="xl26" style="border-left: none;" width="120">Total</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Row I</TD><TD class="xl28"> </TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29951.72</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">8800</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">40674.92</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">74612.46</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">-16337.54</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">25276.65</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">100</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">9388.71</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">14383</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">22162</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">16099</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">41760</TD><TD align="right" class="xl30" style="border-left: none;">266870.92</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Row II</TD><TD class="xl28" style="border-top: none;"> </TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">29659.82</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl29" style="border-top: none; border-left: none;">30969.85</TD><TD align="right" class="xl30" style="border-top: none; border-left: none;">363778.02</TD></TR><TR><TD class="xl27" height="17" style="border-top: none;">Difference</TD><TD class="xl28" style="border-top: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl29" style="border-top: none; border-left: none;"> </TD><TD class="xl30" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P></P><P>- Sasi </P></BODY></HTML> Wed, 10 Apr 2013 21:56:11 GMT https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/442919#M165100 ksasidhars 2013-04-10T21:56:11Z