topic Counting values greater than others in QlikView

Counting values greater than others

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

Everyone on here is always great about helping.

Here is my problem. I have a series of students who have three grades (score 1, score 2, and score 3)

I want to know for how many students was score 1 their best score of the three, how many had score 2 as the best, and how many had score 3 as their best.

Of course, I will take the opposite way as well, how many times was score 1 their worst of the three, etc.

Thanks.

Re: Counting values greater than others

sunny_talwar — Thu, 11 Jan 2018 20:13:12 GMT

Is this something you need to do in the script?

Re: Counting values greater than others

charlesdmeyer — Thu, 11 Jan 2018 20:16:39 GMT

If I can do it in a text box that would be great so I can show it on a report.

Re: Counting values greater than others

sunny_talwar — Thu, 11 Jan 2018 20:19:18 GMT

You can, but I wonder what the output is going to look like in a text box? If there are 300 students out of which 100 have score 1 as there highest, another 100 who have score 2 as highest and the last 100 who have score 3 as highest... what would you want to see in a text box object?

Re: Counting values greater than others

charlesdmeyer — Thu, 11 Jan 2018 20:21:09 GMT

I would try and build three separate boxes just for ease.

Re: Counting values greater than others

sunny_talwar — Thu, 11 Jan 2018 20:26:00 GMT

You can do this

Sum(If(RangeMax(Score1, Score2, Score3) = Score1, 1))

Sum(If(RangeMax(Score1, Score2, Score3) = Score2, 1))

Sum(If(RangeMax(Score1, Score2, Score3) = Score3, 1))