Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Find Max 20 values across table

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_NOABCDEFGHI
12323457623568161
456762356817623756
789568165681623
1234352267762356818
23456762356810176
5687422498376235681
4322568164762388
654375822692835568
678557776235681676
234376235681762365

   

2 Replies
Highlighted
Partner
Partner

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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.