Grouping records

[#1]

Hello everyone!

I am new in this Group. This is my first request for help.

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, ...

Does anyone know an easy way to do this with QlikView?

Thanks in advance

Carlos70

[#2]

Check out the attachment. Hope that answers your question.

Regards,

Kiran.

[its_anandrjs]

Hi,

Use this logic to check the entries

If(Count(ENTRY)=1,'1 Entries',If(Count(ENTRY)=2,'2 Entries',If(Count(ENTRY)=3,'3 Entries')))

HTH

Rgds

Anand

[richard_chilvers]

It looks like you have been given some ideas about how to handle this.

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.

Regards

[its_anandrjs]

Hi,

See the attached sample file.

Rgds

Anand

[#6]

Thanks for the answer, but I guess did not I explain my question well. I hope the attached file will explain it better.

[richard_chilvers]

I think its.anandrjs has given you the answer in the Entries.qvw application above.

Just go to the Properties of the chart and change the chart Type from Table to a Chart and choose your favourite style.

[#8 · Accepted solution]

Updated document with your data. Only problem couldnt get the zero value for 3 entries thought.

Kiran.

[#9]

Thank you very much, Kiran.

Exactly what I needed!

[#10]

Thank you very much, Kiran.

Exactly what I needed!