topic Re: data in QlikView https://community.qlik.com/t5/QlikView/data/m-p/1176569#M911078 <HTML><HEAD></HEAD><BODY><P>now can any one help me in this please its urgent </P></BODY></HTML> Mon, 13 Jun 2016 09:02:51 GMT sagarrahul 2016-06-13T09:02:51Z data https://community.qlik.com/t5/QlikView/data/m-p/1176563#M911072 <HTML><HEAD></HEAD><BODY><P>hiiiii</P><P>want a help in this .</P><P>this is my table .</P><P></P><P>CLM_XGEN_CLAIM_NUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Black List Code</P><P>RC-HS15-10334760&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; H26.9</P><P>RC-HS15-10335711&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; H26.9</P><P>RC-HS15-10341139&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; H26.9</P><P>RC-HS15-10343361&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; H26.9</P><P>RC-HS15-10336529&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; H25.9</P><P>RC-HS15-10336520&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; H26.9</P><P>RC-HS15-10337526&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; H26.9</P><P>&nbsp; -</P><P>RR-HS15-10336940&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; R57.2</P><P></P><P>RR-HS15-10341978 -</P><P>&nbsp; -</P><P>RC-HS15-10333637&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; N18.4</P><P>RR-HS15-10341246&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; N18.9</P><P>&nbsp; -</P><P>RC-HS15-10331178&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; R50.9</P><P></P><P>RR-HS15-10336696&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; N85.2</P><P></P><P>RC-HS15-10343151&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; S52.9</P><P></P><P>RC-HS15-10333670&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; G40.6</P><P>RR-HS15-10341978&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; G40.6</P><P></P><P>RR-HS15-10339968&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; S52.9</P><P></P><P>RC-HS15-10330851&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; A01.0</P><P></P><P>RC-HS15-10344631&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; S83.5</P><P></P><P>&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1) in this i want total count of CLM_XGEN_CLAIM_NUM&nbsp; and&nbsp; total count individual Black List Code </SPAN></P><P></P><P></P><P>2) after geting "point 1" it should divide "CLM_XGEN_CLAIM_NUM / total count individual Black List Code"</P><P></P><P></P><P>3) after diving then if the values goes &gt;=0.7 then is should show as "OUTLIER" othervise "NOT OUTLIER".</P><P></P><P>"help me in Expression "</P><P></P><P>hope u got what i want .</P><P>so please help me in this as soon as possible .</P><P></P><P>for example :</P><P></P><P></P><P>&nbsp; CLM_XGEN_CLAIM_NUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Black List Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status</P><P>&nbsp; RC-HS15-10334760&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P>&nbsp; RC-HS15-10335711&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P>&nbsp; RC-HS15-10341139&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P>&nbsp; RC-HS15-10343361&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P>&nbsp; RC-HS15-10336529&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H25.9</P><P>&nbsp; RC-HS15-10336520&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P>&nbsp; RC-HS15-10337526&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; H26.9</P><P></P><P>total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&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;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OUTLIER</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176563#M911072 sagarrahul 2020-11-25T16:16:04Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176564#M911073 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>1.) =count(CLM_XGEN_CLAIM_NUM)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =count([Black List Code])</P><P></P><P>2.) =count(CLM_XGEN_CLAIM_NUM)/count([Black List Code])</P><P></P><P>3.) =if(count(CLM_XGEN_CLAIM_NUM)/count([Black List Code])&gt;=0.7,'OUTLIER',' NOT OUTLIER')</P></BODY></HTML> Mon, 13 Jun 2016 06:48:47 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176564#M911073 varshavig12 2016-06-13T06:48:47Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176565#M911074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>where you want to present those data?? in chart ? or in text object??</P><P></P><P>Simple count(CLM_XGEN_CLAIM_NUM) return count of CLM_XGEN_CLAIM_NUM</P><P>you can use TOTAL key word for advance expression</P><P>like</P><P><SPAN style="font-size: 13.3333px;">count(TOTAL CLM_XGEN_CLAIM_NUM)</SPAN></P><P><SPAN style="font-size: 13.3333px;">or</SPAN></P><P><SPAN style="font-size: 13.3333px;">If you want group your total w.r.t any dimension then <BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">count(TOTAL&lt;Black List Code&gt; CLM_XGEN_CLAIM_NUM)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P>Regards,</P></BODY></HTML> Mon, 13 Jun 2016 07:03:11 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176565#M911074 PrashantSangle 2016-06-13T07:03:11Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176566#M911075 <HTML><HEAD></HEAD><BODY><P>CountTableClaims:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; Count(Distinct CLM_XGEN_CLAIM_NUM) as CountClaimsTotal</P><P>RESIDENT YourTable;</P><P></P><P>CountTableCodes:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp; Count(Distinct [Black List Code]) as CountCodesTotal</P><P>RESIDENT YourTable;</P><P></P><P>LET vTotalCodes = Peek('CountCodesTotal',0,'CountTableCodes');</P><P>LET vTotalClaims = Peek('CountClaimsTotal',0,'CountTableClaims');</P><P></P><P>Final:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; $(vTotalClaims)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as TOTAL_CLM_XGEN_CLAIM_NUM,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; $(vTotalCodes)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as TOTAL_BLACK_LIST_CODE,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; $(vTotalClaims)/$(vTotalCodes) as Value,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF($(vTotalClaims)/$(vTotalCodes)&lt;0.7 or IsNull($(vTotalClaims)/$(vTotalCodes)),'NOT OUTLIER','OUTLIER') as Status</P><P>AUTOGENERATE 1;</P><P></P><P>Regards!!</P></BODY></HTML> Mon, 13 Jun 2016 07:04:20 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176566#M911075 Anonymous 2016-06-13T07:04:20Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176567#M911076 <HTML><HEAD></HEAD><BODY><P>but i want <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">individual <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">eg 1 : <BR /></SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10333637&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; N18.4</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RR-HS15-10341246&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; N18.9</P><P></P><P>total claim : 2</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code : 2 but different codes</SPAN></P><P>and blacklist code are two but they are different so it should do this&nbsp;&nbsp; :&nbsp; </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1/2=0.5</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">here 1 =N18.4 and 2= total count of claim that is 2 </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">therefore <SPAN style="font-size: 13.3333px;">1/2=0.5 so it is not Outlier </SPAN></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">eg :2<BR /></SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10334760&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10335711&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10341139&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10343361&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10336529&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; H25.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10336520&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10337526&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; H26.9</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">total claim : 7</P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code : 7 same codes</SPAN></P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7/7=1</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">therefore 7/7=1<SPAN style="font-size: 13.3333px;"> so it is" Outlier" </SPAN></SPAN></P></BODY></HTML> Mon, 13 Jun 2016 09:02:07 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176567#M911076 sagarrahul 2016-06-13T09:02:07Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176568#M911077 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">but i want <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">individual <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code</SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;">eg 1 : <BR /></SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10333637&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; N18.4</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RR-HS15-10341246&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; N18.9</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">total claim : 2</P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code : 2 but different codes</SPAN></P><P style="font-size: 13.3333px;">and blacklist code are two but they are different so it should do this&nbsp;&nbsp; :&nbsp; </P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">1/2=0.5</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">here 1 =N18.4 and 2= total count of claim that is 2 </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">therefore <SPAN style="font-size: 13.3333px;">1/2=0.5 so it is not Outlier </SPAN></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">eg :2<BR /></SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10334760&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10335711&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10341139&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10343361&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10336529&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; H25.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10336520&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RC-HS15-10337526&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; H26.9</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">total claim : 7</P><P style="font-size: 13.3333px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Black List Code : 7 same codes</SPAN></P><P></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">7/7=1</SPAN></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">therefore 7/7=1<SPAN style="font-size: 13.3333px;"> so it is" Outlier" </SPAN></SPAN></P></BODY></HTML> Mon, 13 Jun 2016 09:02:18 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176568#M911077 sagarrahul 2016-06-13T09:02:18Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176569#M911078 <HTML><HEAD></HEAD><BODY><P>now can any one help me in this please its urgent </P></BODY></HTML> Mon, 13 Jun 2016 09:02:51 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176569#M911078 sagarrahul 2016-06-13T09:02:51Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176570#M911079 <HTML><HEAD></HEAD><BODY><P>=aggr(count(CLM_XGEN_CLAIM_NUM),[Black List Code])</P><P>=count([Black List Code])</P><P></P><P></P><P>=aggr(count(CLM_XGEN_CLAIM_NUM),[Black List Code])/count([Black List Code])</P><P></P><P>=if(aggr(count(CLM_XGEN_CLAIM_NUM),[Black List Code])/count([Black List Code])&gt;=0.7,'OUTLIER',' NOT OUTLIER')</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127621_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Mon, 13 Jun 2016 09:22:37 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176570#M911079 varshavig12 2016-06-13T09:22:37Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176571#M911080 <HTML><HEAD></HEAD><BODY><P>Hi Sagar,</P><P>Try this attachment,</P></BODY></HTML> Mon, 13 Jun 2016 09:23:12 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176571#M911080 susovan 2016-06-13T09:23:12Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176572#M911081 <HTML><HEAD></HEAD><BODY><P>thank you for ur help help but what want </P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 10pt; font-family: inherit;"><BR /></SPAN></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><SPAN style="font-family: inherit; font-size: 10pt; font-style: inherit; font-weight: inherit; line-height: 1.5em;">eg :2</SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10334760&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10335711&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10341139&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10343361&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10336529&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10336520&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10337526&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; H26.9</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RC-HS15-10333637&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; N18.4</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">RR-HS15-10341246&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; N18.9</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"></P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">total claim : 9</P><P style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 12px;">Black List Code : <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">H26.9 = 7&nbsp;&nbsp; so 7/9 =0.77 , hence its is outlier as it is &gt;=0.7</SPAN></SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&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; N18.4 = 1&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">so 1/9 =0.11 , hence its is not outlier as it is not &gt;=0.7</SPAN></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&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; N18.9 =1&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">so 1/9 =0.11 , hence its is not outlier as it is not &gt;=0.7</SPAN></P></BODY></HTML> Mon, 13 Jun 2016 09:33:53 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176572#M911081 sagarrahul 2016-06-13T09:33:53Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176573#M911082 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try below expression in straight table</P><P></P><P>For Total Claim No</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &gt;Count(TOTAL CLAIM_NO)</P><P></P><P>For Black List Code</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &gt;Sum(aggr(Count(CLAIM_NO),BLACK_CODE))</P><P></P><P>For Status</P><P>&nbsp;&nbsp;&nbsp;&nbsp; &gt; </P><P>IF(Sum(aggr(Count(CLAIM_NO),BLACK_CODE)) </P><P>/ </P><P>Count(TOTAL CLAIM_NO)&gt;=0.7,'OUTLIER',' NOT OUTLIER')</P><P></P><P>Regards</P></BODY></HTML> Mon, 13 Jun 2016 09:50:45 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176573#M911082 PrashantSangle 2016-06-13T09:50:45Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176574#M911083 <HTML><HEAD></HEAD><BODY><P>bro its not working </P></BODY></HTML> Mon, 13 Jun 2016 10:02:12 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176574#M911083 sagarrahul 2016-06-13T10:02:12Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176575#M911084 <HTML><HEAD></HEAD><BODY><P>What issue you are getting??</P><P></P><P>It is working in my machine.</P><P></P><P>Script</P><P></P><P>Table:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp; CLAIM_NO, BLACK_CODE</P><P>&nbsp;&nbsp;&nbsp; RC-HS15-10334760,H26.9</P><P>RC-HS15-10335711,H26.9</P><P>RC-HS15-10341139,H26.9</P><P>RC-HS15-10343361,H26.9</P><P>RC-HS15-10336529,H26.9</P><P>RC-HS15-10336520,H26.9</P><P>RC-HS15-10337526,H26.9</P><P>RC-HS15-10333637,N18.4</P><P>RR-HS15-10341246,N18.9</P><P>];</P><P></P><P>Designer:</P><P></P><P>Straight Table</P><P>Dimension:</P><P>Claim No</P><P>Black Code</P><P>Expression</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">For Total Claim No</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp;&nbsp;&nbsp; &gt;Count(TOTAL CLAIM_NO)</P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">For Black List Code</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp;&nbsp;&nbsp; &gt;Sum(Total&lt;BLACK_CODE&gt; aggr(Count(CLAIM_NO),BLACK_CODE))</P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">For Status</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp;&nbsp;&nbsp; &gt;</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">IF(Sum(Total&lt;BLACK_CODE&gt; aggr(Count(CLAIM_NO),BLACK_CODE))</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">/</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Count(TOTAL CLAIM_NO)&gt;=0.7,'OUTLIER',' NOT OUTLIER')</P><P></P><P></P><P>Regards</P></BODY></HTML> Mon, 13 Jun 2016 10:14:35 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176575#M911084 PrashantSangle 2016-06-13T10:14:35Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176576#M911085 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is this not satisfied your requirement???</P><P></P><P>Regards,</P></BODY></HTML> Mon, 13 Jun 2016 10:23:33 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176576#M911085 PrashantSangle 2016-06-13T10:23:33Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176577#M911086 <HTML><HEAD></HEAD><BODY><P>no bro</P><P>but thanks for ur help an time </P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; line-height: 1.5em;">y .</SPAN></P></BODY></HTML> Mon, 13 Jun 2016 10:40:05 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176577#M911086 sagarrahul 2016-06-13T10:40:05Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176578#M911087 <HTML><HEAD></HEAD><BODY><P>Check this,</P><P><IMG alt="totl data count.JPG" class="jive-image image-1" src="/legacyfs/online/127633_totl data count.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 13 Jun 2016 10:48:57 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176578#M911087 susovan 2016-06-13T10:48:57Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176579#M911088 <HTML><HEAD></HEAD><BODY><P>yes i want this </P></BODY></HTML> Mon, 13 Jun 2016 11:32:25 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176579#M911088 sagarrahul 2016-06-13T11:32:25Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176580#M911089 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Its better than before.</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127738_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Tue, 14 Jun 2016 06:41:11 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176580#M911089 susovan 2016-06-14T06:41:11Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176581#M911090 <HTML><HEAD></HEAD><BODY><P>yes it is better but how to do it susovan ghosh </P><P>can u help me in this </P></BODY></HTML> Tue, 14 Jun 2016 11:52:41 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176581#M911090 sagarrahul 2016-06-14T11:52:41Z Re: data https://community.qlik.com/t5/QlikView/data/m-p/1176582#M911091 <HTML><HEAD></HEAD><BODY><P>Hi Sagar,</P><P>First of all active the design grid option from view,</P><P>than right click of chart -&gt; select "Custom format cell" than choose the column and change the text colour.</P></BODY></HTML> Tue, 14 Jun 2016 12:17:32 GMT https://community.qlik.com/t5/QlikView/data/m-p/1176582#M911091 susovan 2016-06-14T12:17:32Z