topic Filter the Aggr values. in QlikView https://community.qlik.com/t5/QlikView/Filter-the-Aggr-values/m-p/226236#M78454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I use aggr to create a new dimension. the values of the result are 1,2,3</P><P>But I want to get the values greater than and equal to 2.</P><P>How to filter it?</P><P></P><P></P></BODY></HTML> Wed, 23 Feb 2011 03:57:02 GMT 2011-02-23T03:57:02Z Filter the Aggr values. https://community.qlik.com/t5/QlikView/Filter-the-Aggr-values/m-p/226236#M78454 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I use aggr to create a new dimension. the values of the result are 1,2,3</P><P>But I want to get the values greater than and equal to 2.</P><P>How to filter it?</P><P></P><P></P></BODY></HTML> Wed, 23 Feb 2011 03:57:02 GMT https://community.qlik.com/t5/QlikView/Filter-the-Aggr-values/m-p/226236#M78454 2011-02-23T03:57:02Z Filter the Aggr values. https://community.qlik.com/t5/QlikView/Filter-the-Aggr-values/m-p/226237#M78455 <HTML><HEAD></HEAD><BODY><P>=if(aggr(Sum(Amount),Product)=2 ,Product)</P></BODY></HTML> Wed, 23 Feb 2011 04:36:27 GMT https://community.qlik.com/t5/QlikView/Filter-the-Aggr-values/m-p/226237#M78455 2011-02-23T04:36:27Z