Find Max 20 values across table

[neenzkach]

I have a data set that looks like below (There are close to 120 columns)

I need to find the max 20 rank (value and the corresponding column name)  across each project .

ie the max 20 values from multiple columns for each project .

Any ideas on how this can be accomplished ?

Eg: 

Proj_NO	A	B	C	D	E	F	G	H	I
123	23	45	76	23	56	8	1	6	1
456	76	23	56	8	1	76	23	7	56
789	56	8	1	6	56	8	1	6	23
1234	35	22	67	76	23	56	8	1	8
2345	6	76	23	56	8	1	0	1	76
5687	4	22	49	83	76	23	56	8	1
432	2	56	8	1	6	4	76	23	88
6543	7	58	22	6	9	28	35	56	8
678	55	77	76	23	56	8	1	6	76
234	3	76	23	56	8	1	76	23	65

[Vegar]

It might be easier to do if you first perform a Crosstable on your data table before calculating rank.

[Brett_Bleess]

Another link for you regarding the Crosstable that may help with that part of things:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Here is the base Design Blog link you can use to search all the blog posts in this area, there are hundreds of items, most of which are geared toward explaining the more difficult concepts of the products, so you may be able to find some other posts to help you figure out something that will work for you here.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett