topic Formula in QlikView https://community.qlik.com/t5/QlikView/Formula/m-p/171849#M41674 <HTML><HEAD></HEAD><BODY><P>Have you tried something like</P><P>sum(if (AGE &lt; HEIGHT , 1, 0 ))</P><P></P></BODY></HTML> Mon, 08 Mar 2010 22:38:31 GMT 2010-03-08T22:38:31Z Formula https://community.qlik.com/t5/QlikView/Formula/m-p/171848#M41673 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I need to compare 2 figures at an individual record level, and aggregate them at a higher level.</P><P>For example, I want the total number of people per state whose age is less than their height in inches.</P><P>so far, my attempts at drafting a formula in QV to create such a comparison have worked for only those states with just one person in them (who happens to be younger than their height in inches).</P><P>can someone help direct me to find the proper formula?</P><P>thanks!</P></BODY></HTML> Mon, 08 Mar 2010 22:27:50 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/171848#M41673 2010-03-08T22:27:50Z Formula https://community.qlik.com/t5/QlikView/Formula/m-p/171849#M41674 <HTML><HEAD></HEAD><BODY><P>Have you tried something like</P><P>sum(if (AGE &lt; HEIGHT , 1, 0 ))</P><P></P></BODY></HTML> Mon, 08 Mar 2010 22:38:31 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/171849#M41674 2010-03-08T22:38:31Z Formula https://community.qlik.com/t5/QlikView/Formula/m-p/171850#M41675 <HTML><HEAD></HEAD><BODY><P>that worked, thanks! I was using the count formula.....</P></BODY></HTML> Mon, 08 Mar 2010 22:45:14 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/171850#M41675 2010-03-08T22:45:14Z