topic Re: ERROR in QlikView https://community.qlik.com/t5/QlikView/ERROR/m-p/1092376#M920852 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>PFA</P><P></P><P></P><P></P><P>Regards,</P><P>JOSHUA.</P></BODY></HTML> Mon, 25 Apr 2016 05:09:38 GMT ajsjoshua 2016-04-25T05:09:38Z ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092374#M920850 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>i am using this expression and i am getting the answer but a error line appears.</P><P>PFA</P><P></P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092374#M920850 ajsjoshua 2020-11-25T16:16:04Z Re: ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092375#M920851 <HTML><HEAD></HEAD><BODY><P>Are you using your Dimension as Criteria?</P><P>I assume that may not work.</P><P>Could you post sample of this field data?</P></BODY></HTML> Mon, 25 Apr 2016 05:06:04 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092375#M920851 robert_mika 2016-04-25T05:06:04Z Re: ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092376#M920852 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>PFA</P><P></P><P></P><P></P><P>Regards,</P><P>JOSHUA.</P></BODY></HTML> Mon, 25 Apr 2016 05:09:38 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092376#M920852 ajsjoshua 2016-04-25T05:09:38Z Re: ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092377#M920853 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">some PBI's have 2 PKE's and I dont want it counted then.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If PBI's hav 2 PKE's only one should be counted.<BR /></SPAN></P></BODY></HTML> Mon, 25 Apr 2016 05:11:41 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092377#M920853 ajsjoshua 2016-04-25T05:11:41Z Re: ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092378#M920854 <HTML><HEAD></HEAD><BODY><P><EM>Try,</EM></P><P></P><P><EM>=Count(<SPAN style="color: #ff0000;"><STRONG>Distinct</STRONG></SPAN> {&lt;[PBI STATUS]={'Completed'},PKE_ID -= {"PKE_ID****"}&gt;}PBI_ID)</EM></P><P><EM><BR /></EM></P><P><EM><STRONG>Update: Regarding the red error line.</STRONG></EM></P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><EM>This is a bug but you can see "Expression OK" in the expression window. I guess you are using older version and it's fixed in SR10 (Not sure). </EM></SPAN></P></BODY></HTML> Mon, 25 Apr 2016 05:14:17 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092378#M920854 tamilarasu 2016-04-25T05:14:17Z Re: ERROR https://community.qlik.com/t5/QlikView/ERROR/m-p/1092379#M920855 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>=Count(DISTINCT {&lt;[PBI STATUS]={'Completed'},PKE_ID =-{"PKE_ID****"}&gt;}PBI_ID)</P></BODY></HTML> Mon, 25 Apr 2016 05:16:51 GMT https://community.qlik.com/t5/QlikView/ERROR/m-p/1092379#M920855 MayilVahanan 2016-04-25T05:16:51Z