topic Re: how to compare two columns in QlikView https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661139#M240992 <HTML><HEAD></HEAD><BODY><P>expression:</P><P>=if (a=b, sum(measure), 0)</P></BODY></HTML> Wed, 27 Aug 2014 12:53:26 GMT Anonymous 2014-08-27T12:53:26Z how to compare two columns https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661138#M240991 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>i have two columns one measure</P><P></P><P>a&nbsp; b&nbsp;&nbsp;&nbsp; measure</P><P>1&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34</P><P>2&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 56</P><P></P><P>now ouput like </P><P>a&nbsp; b&nbsp;&nbsp;&nbsp; comparision</P><P>1&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34</P><P>2&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>6&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P>what i wnt is if a=b i want show measure value</P><P>if not i want show 0 value</P></BODY></HTML> Wed, 27 Aug 2014 12:51:59 GMT https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661138#M240991 2014-08-27T12:51:59Z Re: how to compare two columns https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661139#M240992 <HTML><HEAD></HEAD><BODY><P>expression:</P><P>=if (a=b, sum(measure), 0)</P></BODY></HTML> Wed, 27 Aug 2014 12:53:26 GMT https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661139#M240992 Anonymous 2014-08-27T12:53:26Z Re: how to compare two columns https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661140#M240993 <HTML><HEAD></HEAD><BODY><P>Try like this expression:</P><P>If(a=b, measure, o)</P></BODY></HTML> Wed, 27 Aug 2014 12:53:38 GMT https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661140#M240993 senpradip007 2014-08-27T12:53:38Z Re: how to compare two columns https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661141#M240994 <HTML><HEAD></HEAD><BODY><P>T simple follow any of the sugestion</P></BODY></HTML> Wed, 27 Aug 2014 12:58:23 GMT https://community.qlik.com/t5/QlikView/how-to-compare-two-columns/m-p/661141#M240994 sujeetsingh 2014-08-27T12:58:23Z