topic Filter data by expression in QlikView https://community.qlik.com/t5/QlikView/Filter-data-by-expression/m-p/430596#M486415 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>How can I add a filter to show only Custormers who had bought N (or more) times within the current selection.</P><P></P><P>For simplicity consider a table with two columns: CustomerID, TicketID</P><P></P><P>So I need to show only Customers with COUNT(Distinct TicketID) &gt;= N</P><P></P><P>The user will enter the value N on a textbox or slider.</P><P></P><P>I suspect that I need an Indirect Set Analysis expression, but not sure how to compose.</P><P></P><P>thanks in advance</P><P>Roberto</P></BODY></HTML> Mon, 11 Mar 2013 22:37:38 GMT rfigueroa 2013-03-11T22:37:38Z Filter data by expression https://community.qlik.com/t5/QlikView/Filter-data-by-expression/m-p/430596#M486415 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>How can I add a filter to show only Custormers who had bought N (or more) times within the current selection.</P><P></P><P>For simplicity consider a table with two columns: CustomerID, TicketID</P><P></P><P>So I need to show only Customers with COUNT(Distinct TicketID) &gt;= N</P><P></P><P>The user will enter the value N on a textbox or slider.</P><P></P><P>I suspect that I need an Indirect Set Analysis expression, but not sure how to compose.</P><P></P><P>thanks in advance</P><P>Roberto</P></BODY></HTML> Mon, 11 Mar 2013 22:37:38 GMT https://community.qlik.com/t5/QlikView/Filter-data-by-expression/m-p/430596#M486415 rfigueroa 2013-03-11T22:37:38Z Re: Filter data by expression https://community.qlik.com/t5/QlikView/Filter-data-by-expression/m-p/430597#M486416 <HTML><HEAD></HEAD><BODY><P>Hola Roberto,</P><P></P><P>¿Hablas español verdad?</P><P></P><P>¿Alguna vez has usado variables? Puedes crear una y usar esa variable para almacenar el valor deseado por el usuario, luego incluirías esa variable dentro de un cuadro de entrada. Por ultimo, incluirías esa variable como parte de una condicional en la expresión de tu tabla o gráfico.</P><P></P><P>En adjunto, un ejemplo.</P><P></P><P>Me cuentas como te fue.</P><P></P><P>Saludos,</P><P>Ricardo</P></BODY></HTML> Tue, 12 Mar 2013 00:50:19 GMT https://community.qlik.com/t5/QlikView/Filter-data-by-expression/m-p/430597#M486416 2013-03-12T00:50:19Z