Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Grouping records

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

1 Solution

Accepted Solutions
Not applicable

Re: Grouping records

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

Kiran.

9 Replies
Not applicable

Re: Grouping records

Check out the attachment. Hope that answers your question.

Regards,

Kiran.

Grouping records

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
Contributor III

Re: Grouping records

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

Re: Grouping records

Hi,

See the attached sample file.

Rgds

Anand

Not applicable

Re: Grouping records

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
Contributor III

Re: Grouping records

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.

Not applicable

Re: Grouping records

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

Kiran.

Not applicable

Re: Grouping records

Thank you very much, Kiran.

Exactly what I needed!

Not applicable

Re: Grouping records

Thank you very much, Kiran.

Exactly what I needed!

Community Browser