topic Grouping records in QlikView https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280104#M582532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this logic to check the entries</P><P></P><P><STRONG>If(Count(ENTRY)=1,'1 Entries',If(Count(ENTRY)=2,'2 Entries',If(Count(ENTRY)=3,'3 Entries')))</STRONG></P><P></P><P>HTH</P><P></P><P>Rgds</P><P>Anand<STRONG><BR /></STRONG></P></BODY></HTML> Thu, 27 Oct 2011 15:32:22 GMT its_anandrjs 2011-10-27T15:32:22Z Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280102#M582530 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>I am new in this Group. This is my first request for help.</P><P></P><P>I am reading a table with two fields: USER and ENTRY. In this table a USER may have done several ENTRIES. I would like to display how many user have done 1 entry, how many user have done 2 entries, 3 entries, ...</P><P></P><P>Does anyone know an easy way to do this with QlikView?</P><P></P><P>Thanks in advance</P><P></P><P>Carlos70</P></BODY></HTML> Thu, 27 Oct 2011 15:14:09 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280102#M582530 2011-10-27T15:14:09Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280103#M582531 <HTML><HEAD></HEAD><BODY><P>Check out the attachment. Hope that answers your question.</P><P></P><P>Regards,</P><P>Kiran.</P></BODY></HTML> Thu, 27 Oct 2011 15:27:11 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280103#M582531 2011-10-27T15:27:11Z Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280104#M582532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this logic to check the entries</P><P></P><P><STRONG>If(Count(ENTRY)=1,'1 Entries',If(Count(ENTRY)=2,'2 Entries',If(Count(ENTRY)=3,'3 Entries')))</STRONG></P><P></P><P>HTH</P><P></P><P>Rgds</P><P>Anand<STRONG><BR /></STRONG></P></BODY></HTML> Thu, 27 Oct 2011 15:32:22 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280104#M582532 its_anandrjs 2011-10-27T15:32:22Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280105#M582533 <HTML><HEAD></HEAD><BODY><P> It looks like you have been given some ideas about how to handle this.</P><P>Don't forget you can also use aggregation functions inside your script. This will be better if you only want to handle data in your application at the aggregated level, because it will reduce the data size.</P><P></P><P>Regards</P></BODY></HTML> Thu, 27 Oct 2011 15:36:26 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280105#M582533 richard_chilvers 2011-10-27T15:36:26Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280106#M582534 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>See the attached sample file. </P><P></P><P>Rgds</P><P>Anand</P></BODY></HTML> Thu, 27 Oct 2011 15:37:50 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280106#M582534 its_anandrjs 2011-10-27T15:37:50Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280107#M582535 <HTML><HEAD></HEAD><BODY><P>Thanks for the answer, but I guess did not I explain my question well. I hope the attached file will explain it better. </P></BODY></HTML> Thu, 27 Oct 2011 16:21:30 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280107#M582535 2011-10-27T16:21:30Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280108#M582536 <HTML><HEAD></HEAD><BODY><P> I think its.anandrjs has given you the answer in the Entries.qvw application above.</P><P>Just go to the Properties of the chart and change the chart Type from Table to a Chart and choose your favourite style.</P></BODY></HTML> Thu, 27 Oct 2011 16:28:49 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280108#M582536 richard_chilvers 2011-10-27T16:28:49Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280109#M582537 <HTML><HEAD></HEAD><BODY><P>Updated document with your data. Only problem couldnt get the zero value for 3 entries thought. </P><P></P><P>Kiran.</P></BODY></HTML> Thu, 27 Oct 2011 16:34:11 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280109#M582537 2011-10-27T16:34:11Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280110#M582538 <HTML><HEAD></HEAD><BODY><P>Thank you very much, Kiran.</P><P>Exactly what I needed!</P></BODY></HTML> Thu, 27 Oct 2011 16:46:47 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280110#M582538 2011-10-27T16:46:47Z Re: Grouping records https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280111#M582540 <HTML><HEAD></HEAD><BODY><P>Thank you very much, Kiran.</P><P>Exactly what I needed!</P></BODY></HTML> Thu, 27 Oct 2011 16:47:10 GMT https://community.qlik.com/t5/QlikView/Grouping-records/m-p/280111#M582540 2011-10-27T16:47:10Z