topic Re: where claus in QlikView https://community.qlik.com/t5/QlikView/where-claus/m-p/787810#M278592 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Count(If(field='clos',field))</SPAN></P></BODY></HTML> Fri, 07 Nov 2014 10:04:45 GMT anbu1984 2014-11-07T10:04:45Z where claus https://community.qlik.com/t5/QlikView/where-claus/m-p/787806#M278588 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i want to execute this request in a text object :</P><P></P><P>select count(field) where field='clos'</P><P></P><P>how can i do that in qlikview???</P></BODY></HTML> Fri, 07 Nov 2014 09:57:28 GMT https://community.qlik.com/t5/QlikView/where-claus/m-p/787806#M278588 2014-11-07T09:57:28Z Re: where claus https://community.qlik.com/t5/QlikView/where-claus/m-p/787807#M278589 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try This one =Count({&lt;field={'clos'}&gt;}field)</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Fri, 07 Nov 2014 09:58:43 GMT https://community.qlik.com/t5/QlikView/where-claus/m-p/787807#M278589 sushil353 2014-11-07T09:58:43Z Re: where claus https://community.qlik.com/t5/QlikView/where-claus/m-p/787808#M278590 <HTML><HEAD></HEAD><BODY><P>Count({$&lt;field = {'clos'}&gt;}field)</P></BODY></HTML> Fri, 07 Nov 2014 10:02:10 GMT https://community.qlik.com/t5/QlikView/where-claus/m-p/787808#M278590 MK_QSL 2014-11-07T10:02:10Z Re: where claus https://community.qlik.com/t5/QlikView/where-claus/m-p/787809#M278591 <HTML><HEAD></HEAD><BODY><P>think u </P></BODY></HTML> Fri, 07 Nov 2014 10:04:37 GMT https://community.qlik.com/t5/QlikView/where-claus/m-p/787809#M278591 2014-11-07T10:04:37Z Re: where claus https://community.qlik.com/t5/QlikView/where-claus/m-p/787810#M278592 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Count(If(field='clos',field))</SPAN></P></BODY></HTML> Fri, 07 Nov 2014 10:04:45 GMT https://community.qlik.com/t5/QlikView/where-claus/m-p/787810#M278592 anbu1984 2014-11-07T10:04:45Z