topic Re: comparing the values in QlikView https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728051#M260918 <HTML><HEAD></HEAD><BODY><P>Yes Jonathan</P><P></P><P>The sales of 2000Q1 in column QuarDIff should be zero and the rest of the values should be compared with the salesYear values and the difference should be placed in the&nbsp; QuarDiff</P><P>Can you share the sample app</P></BODY></HTML> Tue, 30 Sep 2014 14:02:53 GMT Anonymous 2014-09-30T14:02:53Z comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728048#M260915 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I am attaching the application where I need to compare the existing column to the previous column and the resulted value in another column.</P></BODY></HTML> Tue, 30 Sep 2014 12:25:25 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728048#M260915 Anonymous 2014-09-30T12:25:25Z Re: comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728049#M260916 <HTML><HEAD></HEAD><BODY><P>Like this ? </P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67978_Capture.PNG.png" style="width: 620px; height: 305px;" /></P></BODY></HTML> Tue, 30 Sep 2014 13:10:58 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728049#M260916 JonnyPoole 2014-09-30T13:10:58Z Re: comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728050#M260917 <HTML><HEAD></HEAD><BODY><P>Jonathan Poole is right - use the expression he suggests.</P></BODY></HTML> Tue, 30 Sep 2014 13:35:22 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728050#M260917 Anonymous 2014-09-30T13:35:22Z Re: comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728051#M260918 <HTML><HEAD></HEAD><BODY><P>Yes Jonathan</P><P></P><P>The sales of 2000Q1 in column QuarDIff should be zero and the rest of the values should be compared with the salesYear values and the difference should be placed in the&nbsp; QuarDiff</P><P>Can you share the sample app</P></BODY></HTML> Tue, 30 Sep 2014 14:02:53 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728051#M260918 Anonymous 2014-09-30T14:02:53Z Re: Re: comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728052#M260919 <HTML><HEAD></HEAD><BODY><P>Here is the attachment</P></BODY></HTML> Tue, 30 Sep 2014 14:13:08 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728052#M260919 JonnyPoole 2014-09-30T14:13:08Z Re: comparing the values https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728053#M260920 <HTML><HEAD></HEAD><BODY><P>Hi Jonathan ,</P><P><A _jive_internal="true" href="https://community.qlik.com/message/627479#627479">http://community.qlik.com/message/627479#627479</A></P><P>I need all the data to be shown and&nbsp; I am seeking your suggestions on the above post regarding the sub-field issue.</P><P>Hope you would resolve my issue</P></BODY></HTML> Tue, 07 Oct 2014 08:11:29 GMT https://community.qlik.com/t5/QlikView/comparing-the-values/m-p/728053#M260920 Anonymous 2014-10-07T08:11:29Z