topic Re: Show ONLY the highest RANK in QlikView in App Development

Show ONLY the highest RANK in QlikView

LearnFreak — Fri, 30 Sep 2022 08:10:00 GMT

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.

tresB — Fri, 30 Sep 2022 08:17:24 GMT

Try using alt(), like:

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

LearnFreak — Fri, 30 Sep 2022 08:24:47 GMT

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 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 — Fri, 30 Sep 2022 08:36:19 GMT

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

tresB — Fri, 30 Sep 2022 09:05:43 GMT

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

LearnFreak — Fri, 30 Sep 2022 10:10:02 GMT

I tried like this in attachment.

Thank you.

LearnFreak — Wed, 05 Oct 2022 12:36:31 GMT

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