topic Re: How to show difference in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347708#M1173115 <HTML><HEAD></HEAD><BODY><P>It might be easier to just use 3 expressions.</P></BODY></HTML> Fri, 11 May 2012 14:56:26 GMT 2012-05-11T14:56:26Z How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347703#M1173110 <HTML><HEAD></HEAD><BODY><P> Greeting All,</P><P></P><P>Please find the attached qvw file.</P><P></P><P>Please suggest how to calculate the difference where the value of IMS and IRR in -ve.</P><P></P><P>Thanks...!! </P></BODY></HTML> Fri, 11 May 2012 13:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347703#M1173110 2012-05-11T13:40:33Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347704#M1173111 <HTML><HEAD></HEAD><BODY><P>Anyone??</P></BODY></HTML> Fri, 11 May 2012 14:07:56 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347704#M1173111 2012-05-11T14:07:56Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347705#M1173112 <HTML><HEAD></HEAD><BODY><P>What is the problem here. It is coming exactly right.</P><P>-62-62=-124 only.</P></BODY></HTML> Fri, 11 May 2012 14:24:15 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347705#M1173112 jagannalla 2012-05-11T14:24:15Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347706#M1173113 <HTML><HEAD></HEAD><BODY><P>Thanks for responding..!!</P><P></P><P>It is -62- (-62)</P><P>=&gt; -62+62</P><P>=&gt;0</P><P></P><P>It implies the value of IMS = IRR , so the difference should be zero.</P><P>But it is not differentiating correctly on -ve values.</P></BODY></HTML> Fri, 11 May 2012 14:30:29 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347706#M1173113 2012-05-11T14:30:29Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347707#M1173114 <HTML><HEAD></HEAD><BODY><P>No no.. if you choose show paritial Sums it works like below</P><P></P><P>-62+(-62) </P><P>= -62-62</P><P>=-124</P></BODY></HTML> Fri, 11 May 2012 14:40:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347707#M1173114 jagannalla 2012-05-11T14:40:23Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347708#M1173115 <HTML><HEAD></HEAD><BODY><P>It might be easier to just use 3 expressions.</P></BODY></HTML> Fri, 11 May 2012 14:56:26 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347708#M1173115 2012-05-11T14:56:26Z Re: How to show difference in pivot table https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347709#M1173116 <HTML><HEAD></HEAD><BODY><P>Yeah, it works..!</P><P></P><P>We also can use columnno() instead of dimensionality().</P></BODY></HTML> Fri, 11 May 2012 15:25:18 GMT https://community.qlik.com/t5/QlikView/How-to-show-difference-in-pivot-table/m-p/347709#M1173116 2012-05-11T15:25:18Z