topic Calculating Row wise differences in QlikView https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/441976#M164768 <HTML><HEAD></HEAD><BODY><P>Hi - Can anybody let me know how to achiev a row wise differences.</P><P></P><P>For Example the 'Name' and 'Month' are the existing fields in the Pivot below, How can I calculate difference here. The data is coming dfrom a huge Fact with many columns. </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 align="right" class="xl29" style="border-top: none; border-left: none;">105.6</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>Thanks for the advise!</P><P></P><P>Regards,</P><P>Sasi</P></BODY></HTML> Wed, 10 Apr 2013 19:06:08 GMT ksasidhars 2013-04-10T19:06:08Z Calculating Row wise differences https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/441976#M164768 <HTML><HEAD></HEAD><BODY><P>Hi - Can anybody let me know how to achiev a row wise differences.</P><P></P><P>For Example the 'Name' and 'Month' are the existing fields in the Pivot below, How can I calculate difference here. The data is coming dfrom a huge Fact with many columns. </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 align="right" class="xl29" style="border-top: none; border-left: none;">105.6</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>Thanks for the advise!</P><P></P><P>Regards,</P><P>Sasi</P></BODY></HTML> Wed, 10 Apr 2013 19:06:08 GMT https://community.qlik.com/t5/QlikView/Calculating-Row-wise-differences/m-p/441976#M164768 ksasidhars 2013-04-10T19:06:08Z