Show ONLY the highest RANK in QlikView

[LearnFreak]

Hi,

I have done a ranking in my LoadScript and I have a Straight Table where I need to show only the highest rank of a person. This is my logic:

Rank 1 - as the highest rank

If Rank 1 = NULL > Rank 2

IF Rank 2 = NULL > Rank 3

IF Rank 3 = NULL > Rank 4

IF Rank 4 = NULL > Rank 5

IF Rank 5 = NULL > Rank 6

IF Rank 6 = NULL > NO RESULT

Do you have any idea how to set an expression in the table itself?

Thank you.

[tresesco]

Try using alt(), like:

Alt(rank1, rank2, ..., 'no result')

[LearnFreak]

But I have several values for Rank 1, several for Rank 2 etc...

For example, I have like this

Column name:       Categories

Values in the column per rank:   

'Rank 1  xxxxx'

'Rank 1 xxxxx'

'Rank 1 xxxxxx'

'Rank 2 xxxxxx'

'Rank 2 xxxxxx'

'Rank 3 xxxxxx' etc.

I need to show all the values there are for each person but for his highest rank. 

So if a person has values in all categories I need to show only the values of his highest rank.

[LearnFreak]

I tried this solution and I got 'no result' everywhere 🙂

[tresesco]

Try to share a sample data set and expected output against that. I will try to provide a solution accordingly.

[LearnFreak]

I tried like this in attachment.

Thank you.

[LearnFreak]

Hi, I wondered if you tried with the sample I provided? Thank you...