topic Re: Find Max 20 values across table in QlikView

Find Max 20 values across table

neenzkach — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Find Max 20 values across table

Vegar — Mon, 23 Sep 2019 17:50:15 GMT

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

Re: Find Max 20 values across table

Brett_Bleess — Wed, 02 Oct 2019 18:37:04 GMT

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