Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Updated document with your data. Only problem couldnt get the zero value for 3 entries thought.
Kiran.
Check out the attachment. Hope that answers your question.
Regards,
Kiran.
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
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
Hi,
See the attached sample file.
Rgds
Anand
Thanks for the answer, but I guess did not I explain my question well. I hope the attached file will explain it better.
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.
Updated document with your data. Only problem couldnt get the zero value for 3 entries thought.
Kiran.
Thank you very much, Kiran.
Exactly what I needed!
Thank you very much, Kiran.
Exactly what I needed!