https://community.qlik.com/t5/QlikView/Couting-greater-than-limits/m-p/1599691#M737967 <P>Correct the parentheses and use a sum:&nbsp;</P><P><EM>Sum(if(amount &gt; highlimit, 1, 0))<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ^&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;^&nbsp; &nbsp; &nbsp; &nbsp; ^</EM></P><P>&nbsp;</P> Mon, 08 Jul 2019 06:00:37 GMT jonathandienst 2019-07-08T06:00:37Z https://community.qlik.com/t5/QlikView/Couting-greater-than-limits/m-p/1599686#M737966 <P>Hi,&nbsp;<BR />I'm new to Qliksense and I have an issues comparing two fields to get the count values<BR /><BR />In my datasets i have an amount variable and a high limit set for it.&nbsp;</P><P>I used&nbsp; the condition&nbsp;<BR />Count(if(amount) &gt; [highlimit]),1,0)&nbsp; but i'm getting an error.&nbsp;<BR />My goal is to find all the amount values greater than the high limit field and count each of those values as 1&nbsp;<BR /><BR /></P><P>Thanks for the help!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Couting-greater-than-limits/m-p/1599686#M737966 Qliksense7 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Couting-greater-than-limits/m-p/1599691#M737967 <P>Correct the parentheses and use a sum:&nbsp;</P><P><EM>Sum(if(amount &gt; highlimit, 1, 0))<BR />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ^&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;^&nbsp; &nbsp; &nbsp; &nbsp; ^</EM></P><P>&nbsp;</P> Mon, 08 Jul 2019 06:00:37 GMT https://community.qlik.com/t5/QlikView/Couting-greater-than-limits/m-p/1599691#M737967 jonathandienst 2019-07-08T06:00:37Z