topic Re: Top 10 Table in QlikView

Top 10 Table

Mon, 19 May 2014 12:13:17 GMT

Hi Folks

I hope you can offer some guidance,

I have data that identifies different activities and which user did what ,

User	Task	Number
Anne	Selling	10
John	Buying	15
Fred	Logging	5
John	Selling	5
Fred	Buying	10
Trevor	Logging	16

I am looking to build a Top 10 preformer per task - so looks something like

User	Task	User Total	Total	% for user
Anne	Selling	10	15	66.67%
John	Buying	15	25	60.00%
Trevor	Logging	16	21	76.19%

Can anyone give me guidance ? Or if they have an example it would be really appreciated

Thanks

Re: Top 10 Table

anbu1984 — Mon, 19 May 2014 12:25:25 GMT

Check this app

Re: Top 10 Table

Mon, 19 May 2014 12:32:11 GMT

Hi Anbu

Thanks for the attached -

I had actually managed it that far to have top 10 overall , my issue is trying to get the top person per task - do you think I should just put in a set for each task ?

Thanks

Re: Top 10 Table

Mon, 19 May 2014 12:35:13 GMT

Don't see how to do it within 1 table. I would make some text fields and create the top 10 in there with the use of set expressions. But that would not be easy for export.

Re: Top 10 Table

Mon, 19 May 2014 12:35:52 GMT

Salesman	Product ID	Sales	Overall %	Total sales
Charles Ingvar Jönsson	1000	17678	56%	31766
Charles Ingvar Jönsson	2000	28330	45%	63545
Olivier Simenon	3000	56789	54%	104215
Bill Yang	4000	112220	49%	230087
Lucky Luke	5000	127432	41%	313649

So the Bottom Left chart would look like above

Thanks

Re: Top 10 Table

Mon, 19 May 2014 12:36:40 GMT

Thanks Coen,

maybe thats the way forward using Text box

Thanks

Re: Re: Top 10 Table

anbu1984 — Mon, 19 May 2014 12:37:41 GMT

Check this updated app with top 5 in each country

Re: Top 10 Table

Mon, 19 May 2014 12:44:27 GMT

Thanks Anbu

This looks like the solution for me

Appreciate it