topic Re: Need Help.. in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/846157#M996162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Kindly mark question as answered</P></BODY></HTML> Tue, 30 Jun 2015 06:12:17 GMT timanshu 2015-06-30T06:12:17Z Need Help.. https://community.qlik.com/t5/QlikView/Need-Help/m-p/846153#M996158 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one pivot table,</P><P>Dimensions :&nbsp; ID, Month and Status</P><P>Measure:&nbsp; Count(Status)</P><P></P><P>I want show only Count(ID) greater than 2, i have duplicate ID's depends on status....</P><P>I am using in Dimension <STRONG>if(Count(ID)&gt;2, ID)</STRONG></P><P></P><P>But, it showing error.. any thing wrong here....</P></BODY></HTML> Tue, 30 Jun 2015 03:39:24 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/846153#M996158 paulwalker 2015-06-30T03:39:24Z Re: Need Help.. https://community.qlik.com/t5/QlikView/Need-Help/m-p/846154#M996159 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Please try this once</P><P></P><P>if(count(distinct(id)&gt;2,id)</P><P></P><P>Thank you</P><P>Suresh</P></BODY></HTML> Tue, 30 Jun 2015 03:59:10 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/846154#M996159 Chanty4u 2015-06-30T03:59:10Z Re: Need Help.. https://community.qlik.com/t5/QlikView/Need-Help/m-p/846155#M996160 <HTML><HEAD></HEAD><BODY><P>Yeah, I got it..</P><P>I have used this expression...</P><P>=if(Aggr(Count(ID),ID)&gt;1,ID)</P></BODY></HTML> Tue, 30 Jun 2015 04:06:03 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/846155#M996160 paulwalker 2015-06-30T04:06:03Z Re: Need Help.. https://community.qlik.com/t5/QlikView/Need-Help/m-p/846156#M996161 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> good</P></BODY></HTML> Tue, 30 Jun 2015 04:26:27 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/846156#M996161 Chanty4u 2015-06-30T04:26:27Z Re: Need Help.. https://community.qlik.com/t5/QlikView/Need-Help/m-p/846157#M996162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Kindly mark question as answered</P></BODY></HTML> Tue, 30 Jun 2015 06:12:17 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/846157#M996162 timanshu 2015-06-30T06:12:17Z